{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["gl. til nyt niveau","reguleringsprocenter","Lønark","Forside","Omregningstabel ","Tillæg_trin","Tillæg_kr","Omregner_gl. til nyt_niveau","Tid op_ned","Samlet_omk","Omregner_'18_niveau"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":83,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"gl. til nyt niveau","index":0,"n_rows":395,"n_cols":6,"rows_kept":395,"cut":false,"hidden":true,"merged":[]}
[null,1.3980790000000001]
[null,null,null,"Nyt grundbeløb","Nyt grundbeløb"]
["Grundbeløb pr. 1/10-1984","I alt pr. 1. april 1999 inkl. %regulering",null,"pr. 31/3-2000","pr. 31/3-2000"]
[null,null,null,"ekskl. afrunding","inkl. afrunding"]
[null,null,null,null,null,"beløb"]
[null,"pr. gang/år","pr. måned",null,null,"+/-"]
[1.63,{"$f":"IF(A7<1000,$B$1*A7,ROUND($B$1*A7,0))","v":2.2788687699999999},null,{"$f":"B7","v":2.2788687699999999},{"$f":"IF(D7<1000,D7,ROUND(D7,-2))","v":2.2788687699999999}]
[5,6.9903950000000004,null,{"$f":"B8","v":6.9903950000000004},6.9903950000000004]
[5.8,8.1088582000000002,null,8.1088582000000002,8.1088582000000002]
[9,12.582711,null,12.582711,12.582711]
[10.5,14.6798295,null,14.6798295,14.6798295]
[12.22,17.084525380000002,null,17.084525380000002,17.084525380000002]
[12.65,17.68569935,null,17.68569935,17.68569935]
[13.39,18.720277810000002,null,18.720277810000002,18.720277810000002]
[13.75,19.22358625,null,19.22358625,19.22358625]
[14.46,20.216222340000002,null,20.216222340000002,20.216222340000002]
[15.2,21.2508008,null,21.2508008,21.2508008]
[15.5,21.6702245,null,21.6702245,21.6702245]
[17,23.767343,null,23.767343,23.767343]
[18.5,25.864461500000001,null,25.864461500000001,25.864461500000001]
[19,26.563501000000002,null,26.563501000000002,26.563501000000002]
[21,29.359659000000001,null,29.359659000000001,29.359659000000001]
[23,32.155816999999999,null,32.155816999999999,32.155816999999999]
[24.97,34.910032630000003,null,34.910032630000003,34.910032630000003]
[28,39.146212000000006,null,39.146212000000006,39.146212000000006]
[30,41.942370000000004,null,41.942370000000004,41.942370000000004]
[33.29,46.542049910000003,null,46.542049910000003,46.542049910000003]
[42,58.719318000000001,null,58.719318000000001,58.719318000000001]
[61.26,85.646319540000007,null,85.646319540000007,85.646319540000007]
[62,86.680897999999999,null,86.680897999999999,86.680897999999999]
[68.319999999999993,95.516757279999993,null,95.516757279999993,95.516757279999993]
[75.13,105.03767526999999,null,105.03767526999999,105.03767526999999]
[80.38,112.37759002,null,112.37759002,112.37759002]
[136.63999999999999,191.03351455999999,null,{"$f":"B34","v":191.03351455999999},191.03351455999999]
[143.99,201.30939521000002,null,{"$f":"B35","v":201.30939521000002},201.30939521000002]
[150.61000000000001,210.56467819000002,null,210.56467819000002,210.56467819000002]
[164,229.28495600000002,null,229.28495600000002,229.28495600000002]
[170,237.67343000000002,null,237.67343000000002,237.67343000000002]
[190,265.63501000000002,null,265.63501000000002,{"$f":"IF(D39<1000,D39,ROUND(D39,-2))","v":265.63501000000002}]
[195,272.625405,null,272.625405,272.625405]
[202,282.41195800000003,null,282.41195800000003,282.41195800000003]
[260,363.50054,null,363.50054,363.50054]
[278,388.66596200000004,null,388.66596200000004,388.66596200000004]
[300.83999999999997,420.59808635999997,null,420.59808635999997,420.59808635999997]
[350,489.32765000000001,null,489.32765000000001,489.32765000000001]
[380,531.27002000000005,null,531.27002000000005,531.27002000000005]
[398.95,557.76361704999999,null,557.76361704999999,557.76361704999999]
[420,587.19317999999998,null,587.19317999999998,587.19317999999998]
[465,650.10673500000007,null,650.10673500000007,650.10673500000007]
[490,685.05871000000002,null,685.05871000000002,685.05871000000002]
[502,701.83565800000008,null,701.83565800000008,701.83565800000008]
[559,781.526161,null,781.526161,781.526161]
[597,834.65316300000006,null,834.65316300000006,834.65316300000006]
[700,978.65530000000001,{"$f":"VALUE(B54)/12","v":81.554608333333334},978.65530000000001,{"$f":"IF(D54<1000,D54,ROUND(D54,-2))","v":978.65530000000001},{"$f":"E54-D54","v":0}]
[750,1048.55925,87.379937499999997,1048.55925,{"$f":"IF(D55<1000,D55,ROUND(D55,-2))","v":1000},-48.55925000000002]
[800,1118.4632000000001,93.205266666666674,1118.4632000000001,{"$f":"IF(D56<1000,D56,ROUND(D56,-2))","v":1100},-18.463200000000143]
[842.75,1178.23107725,98.185923104166662,1178.23107725,1200,21.768922750000002]
[868,1213.5325720000001,101.12771433333334,1213.5325720000001,1200,-13.532572000000073]
[917.14,1282.23417406,106.85284783833333,{"$f":"B59","v":1282.23417406},1300,17.765825940000013]
[920,1286.2326800000001,107.18605666666667,1286.2326800000001,1300,13.767319999999927]
[925,1293.2230750000001,107.76858958333334,1293.2230750000001,1300,6.776924999999892]
[950,{"$f":"IF(A62<1000,$B$1*A62,ROUND($B$1*A62,0))","v":1328.1750500000001},110.68125416666668,1328.1750500000001,1300,-28.175050000000056]
[1000,{"$f":"IF(A63<1000,$B$1*A63,ROUND($B$1*A63,0))","v":1398},116.5,1398,1400,2]
[1050,{"$f":"IF(A64<1000,$B$1*A64,ROUND($B$1*A64,0))","v":1468},122.33333333333333,1468,1500,32]
[1100,{"$f":"IF(A65<1000,$B$1*A65,ROUND($B$1*A65,0))","v":1538},128.16666666666666,1538,1500,-38]
[1200,1678,139.83333333333334,1678,1700,22]
[1245,1741,145.08333333333334,{"$f":"B67","v":1741},1700,{"$f":"E67-D67","v":-41}]
[1300,1818,151.5,1818,1800,-18]
[1327,1855,154.58333333333334,1855,1900,45]
[1400,1957,163.08333333333334,1957,2000,43]
[1500,2097,174.75,2097,2100,3]
[1600,2237,186.41666666666666,2237,2200,-37]
[1700,2377,198.08333333333334,2377,2400,23]
[1750,2447,203.91666666666666,2447,2400,-47]
[1800,2517,209.75,2517,2500,-17]
[1900,2656,221.33333333333334,2656,2700,44]
[2000,2796,233,2796,2800,4]
[2050,2866,238.83333333333334,2866,2900,34]
[2100,2936,244.66666666666666,2936,2900,-36]
[2145,2999,249.91666666666666,2999,3000,1]
[2150,3006,250.5,3006,3000,-6]
[2200,3076,256.33333333333331,3076,3100,24]
[2300,3216,268,3216,3200,-16]
[2400,3355,279.58333333333331,3355,3400,45]
[2450,3425,285.41666666666669,3425,3400,-25]
[2500,3495,291.25,3495,3500,5]
[2600,3635,302.91666666666669,3635,3600,-35]
[2700,3775,314.58333333333331,3775,3800,25]
[2730,3817,318.08333333333331,3817,3800,-17]
[2800,3915,326.25,3915,3900,-15]
[2900,4054,337.83333333333331,4054,4100,46]
[3000,4194,349.5,4194,4200,6]
[3100,4334,361.16666666666669,4334,4300,-34]
[3200,4474,372.83333333333331,4474,4500,26]
[3300,4614,384.5,4614,4600,-14]
[3400,4753,396.08333333333331,4753,4800,47]
[3500,4893,407.75,4893,4900,7]
[3600,5033,419.41666666666669,5033,5000,-33]
[3700,5173,431.08333333333331,5173,5200,27]
[3800,5313,442.75,5313,5300,-13]
[3900,5453,454.41666666666669,5453,5500,47]
[4000,5592,466,5592,5600,8]
[4100,5732,477.66666666666669,5732,5700,-32]
[4200,5872,489.33333333333331,5872,5900,28]
[4226.1000000000004,5908,492.33333333333331,5908,5900,-8]
[4300,6012,501,6012,6000,-12]
[4400,6152,512.66666666666663,6152,6200,48]
[4430,6193,516.08333333333337,6193,6200,7]
[4500,6291,524.25,6291,6300,9]
[4600,6431,535.91666666666663,6431,6400,-31]
[4700,6571,547.58333333333337,6571,6600,29]
[1770,2475,206.25,2475,2500,25]
[4800,6711,559.25,6711,6700,-11]
[4900,6851,570.91666666666663,6851,6900,49]
[4930,6893,574.41666666666663,6893,6900,7]
[5000,6990,582.5,6990,7000,10]
[5100,7130,594.16666666666663,7130,7100,-30]
[5200,7270,{"$f":"VALUE(B118)/12","v":605.83333333333337},7270,7300,30]
[5300,7410,617.5,7410,7400,-10]
[5318,7435,619.58333333333337,7435,{"$f":"IF(D120<1000,D120,ROUND(D120,-2))","v":7400},-35]
[5400,7550,629.16666666666663,7550,7600,50]
[5420.91,7579,631.58333333333337,7579,7600,21]
[5500,7689,640.75,{"$f":"B123","v":7689},7700,{"$f":"E123-D123","v":11}]
[5600,7829,652.41666666666663,7829,7800,-29]
[5700,7969,664.08333333333337,7969,8000,31]
[5770.78,8068,672.33333333333337,8068,8100,32]
[5800,8109,675.75,8109,8100,-9]
[5900,8249,687.41666666666663,8249,8200,-49]
[6000,{"$f":"IF(A129<1000,$B$1*A129,ROUND($B$1*A129,0))","v":8388},699,8388,8400,12]
[6078,8498,708.16666666666663,8498,8500,2]
[6100,8528,710.66666666666663,8528,8500,-28]
[6140,8584,715.33333333333337,8584,8600,16]
[6200,8668,722.33333333333337,8668,8700,32]
[6290.15,8794,732.83333333333337,8794,8800,6]
[6300,8808,734,8808,8800,-8]
[6400,8948,745.66666666666663,8948,8900,-48]
[6500,9088,757.33333333333337,9088,9100,12]
[6600,9227,768.91666666666663,9227,9200,-27]
[6700,9367,780.58333333333337,9367,9400,33]
[6743.33,9428,785.66666666666663,9428,9400,-28]
[6800,9507,792.25,9507,9500,-7]
[6900,9647,803.91666666666663,9647,9600,-47]
[7000,9787,815.58333333333337,9787,9800,13]
[7100,9926,827.16666666666663,9926,9900,-26]
[7200,10066,838.83333333333337,10066,10100,34]
[7300,10206,850.5,10206,10200,-6]
[7335.23,10255,854.58333333333337,10255,10300,45]
[7400,10346,862.16666666666663,10346,10300,-46]
[7500,10486,873.83333333333337,10486,10500,14]
[7600,10625,885.41666666666663,10625,10600,-25]
[7700,10765,897.08333333333337,10765,10800,35]
[7800,10905,908.75,10905,10900,-5]
[7900,11045,920.41666666666663,11045,11000,-45]
[8000,11185,932.08333333333337,11185,11200,15]
[8100,11324,943.66666666666663,11324,11300,-24]
[8200,11464,955.33333333333337,11464,11500,36]
[8300,11604,967,11604,11600,-4]
[8400,11744,978.66666666666663,11744,11700,-44]
[8500,11884,990.33333333333337,11884,11900,16]
[8600,12023,1001.9166666666666,12023,12000,-23]
[8700,12163,1013.5833333333334,12163,12200,37]
[8800,12303,1025.25,12303,12300,-3]
[8900,12443,1036.9166666666667,12443,12400,-43]
[9000,12583,1048.5833333333333,12583,12600,17]
[9100,12723,1060.25,12723,12700,-23]
[9200,12862,1071.8333333333333,12862,12900,38]
[9300,13002,1083.5,13002,13000,-2]
[9400,13142,1095.1666666666667,13142,13100,-42]
[9450,13212,1101,13212,13200,-12]
[9500,13282,1106.8333333333333,13282,13300,18]
[9600,13422,1118.5,13422,13400,-22]
[9700,13561,1130.0833333333333,13561,13600,39]
[9800,13701,1141.75,13701,13700,-1]
[9900,13841,1153.4166666666667,13841,13800,-41]
[10000,13981,1165.0833333333333,13981,14000,19]
[10600,14820,1235,14820,14800,-20]
[10800,15099,1258.25,15099,15100,1]
[11000,15379,1281.5833333333333,15379,15400,21]
[11200,15658,1304.8333333333333,15658,15700,42]
[11300,15798,1316.5,15798,15800,2]
[11500,16078,1339.8333333333333,16078,16100,22]
[11600,16218,{"$f":"VALUE(B182)/12","v":1351.5},16218,16200,-18]
[11700,16358,1363.1666666666667,16358,16400,42]
[11800,16497,1374.75,16497,{"$f":"IF(D184<1000,D184,ROUND(D184,-2))","v":16500},3]
[11900,16637,1386.4166666666667,16637,16600,-37]
[12000,16777,1398.0833333333333,16777,16800,23]
[12100,16917,1409.75,{"$f":"B187","v":16917},16900,{"$f":"E187-D187","v":-17}]
[12200,17057,1421.4166666666667,17057,17100,43]
[12300,17196,1433,17196,17200,4]
[12400,17336,1444.6666666666667,17336,17300,-36]
[12500,17476,1456.3333333333333,17476,17500,24]
[12600,17616,1468,17616,17600,-16]
[12700,{"$f":"IF(A193<1000,$B$1*A193,ROUND($B$1*A193,0))","v":17756},1479.6666666666667,17756,17800,44]
[12800,17895,1491.25,17895,17900,5]
[12900,18035,1502.9166666666667,18035,18000,-35]
[13000,18175,1514.5833333333333,18175,18200,25]
[13200,18455,1537.9166666666667,18455,18500,45]
[13400,18734,1561.1666666666667,18734,18700,-34]
[13500,18874,1572.8333333333333,18874,18900,26]
[13700,19154,1596.1666666666667,19154,19200,46]
[14000,19573,1631.0833333333333,19573,19600,27]
[14300,19993,1666.0833333333333,19993,20000,7]
[14500,20272,1689.3333333333333,20272,20300,28]
[14700,20552,1712.6666666666667,20552,20600,48]
[14800,20692,1724.3333333333333,20692,20700,8]
[14900,20831,1735.9166666666667,20831,20800,-31]
[15000,20971,1747.5833333333333,20971,21000,29]
[15100,21111,1759.25,21111,21100,-11]
[15200,21251,1770.9166666666667,21251,21300,49]
[15500,21670,1805.8333333333333,21670,21700,30]
[15700,21950,1829.1666666666667,21950,22000,50]
[15900,22229,1852.4166666666667,22229,22200,-29]
[16000,22369,1864.0833333333333,22369,22400,31]
[16100,22509,1875.75,22509,22500,-9]
[16200,22649,1887.4166666666667,22649,22600,-49]
[16700,23348,1945.6666666666667,23348,23300,-48]
[16800,23488,1957.3333333333333,23488,23500,12]
[16900,23628,1969,23628,23600,-28]
[17000,23767,1980.5833333333333,23767,23800,33]
[17100,23907,1992.25,23907,23900,-7]
[17600,24606,2050.5,24606,24600,-6]
[17700,24746,2062.1666666666665,24746,24700,-46]
[18000,25165,2097.0833333333335,25165,25200,35]
[18200,25445,2120.4166666666665,25445,25400,-45]
[18300,25585,2132.0833333333335,25585,25600,15]
[18600,26004,2167,26004,26000,-4]
[18700,26144,2178.6666666666665,26144,26100,-44]
[18800,26284,2190.3333333333335,{"$f":"B228","v":26284},26300,{"$f":"E228-D228","v":16}]
[18900,26424,2202,26424,26400,-24]
[19000,26564,2213.6666666666665,26564,26600,36]
[19100,26703,2225.25,26703,26700,-3]
[19400,27123,2260.25,27123,27100,-23]
[19500,27263,2271.9166666666665,27263,27300,37]
[19600,27402,2283.5,27402,27400,-2]
[19700,27542,2295.1666666666665,27542,27500,-42]
[20000,27962,2330.1666666666665,27962,28000,38]
[20300,28381,2365.0833333333335,28381,28400,19]
[20400,28521,2376.75,28521,28500,-21]
[20500,28661,2388.4166666666665,28661,28700,39]
[20800,29080,2423.3333333333335,29080,29100,20]
[20900,29220,2435,29220,29200,-20]
[21100,29499,2458.25,29499,29500,1]
[21300,29779,2481.5833333333335,29779,29800,21]
[21900,30618,2551.5,30618,30600,-18]
[22000,30758,2563.1666666666665,30758,30800,42]
[22200,31037,{"$f":"VALUE(B246)/12","v":2586.4166666666665},31037,31000,-37]
[22400,31317,2609.75,31317,31300,-17]
[22500,31457,2621.4166666666665,31457,{"$f":"IF(D248<1000,D248,ROUND(D248,-2))","v":31500},43]
[22600,31597,2633.0833333333335,31597,31600,3]
[22900,32016,2668,32016,32000,-16]
[23000,32156,2679.6666666666665,32156,32200,44]
[23200,32435,2702.9166666666665,32435,32400,-35]
[23300,32575,2714.5833333333335,32575,32600,25]
[23400,32715,2726.25,32715,32700,-15]
[23500,32855,2737.9166666666665,32855,32900,45]
[23600,32995,2749.5833333333335,32995,33000,5]
[23700,{"$f":"IF(A257<1000,$B$1*A257,ROUND($B$1*A257,0))","v":33134},2761.1666666666665,33134,33100,-34]
[23800,33274,2772.8333333333335,33274,33300,26]
[23900,33414,2784.5,33414,33400,-14]
[24000,33554,2796.1666666666665,33554,33600,46]
[24500,34253,2854.4166666666665,34253,34300,47]
[24900,34812,2901,34812,34800,-12]
[25000,34952,2912.6666666666665,34952,35000,48]
[25200,35232,2936,35232,35200,-32]
[25400,35511,2959.25,35511,35500,-11]
[25700,35931,2994.25,35931,35900,-31]
[26000,36350,3029.1666666666665,36350,36400,50]
[26300,36769,3064.0833333333335,36769,36800,31]
[26600,37189,3099.0833333333335,37189,37200,11]
[26700,37329,3110.75,37329,37300,-29]
[26900,37608,3134,37608,37600,-8]
[27000,37748,3145.6666666666665,37748,37700,-48]
[27100,37888,3157.3333333333335,37888,37900,12]
[27600,38587,3215.5833333333335,38587,38600,13]
[27700,38727,3227.25,38727,38700,-27]
[28000,39146,3262.1666666666665,39146,39100,-46]
[28100,39286,3273.8333333333335,39286,39300,14]
[29000,40544,3378.6666666666665,40544,40500,-44]
[29100,40684,3390.3333333333335,40684,40700,16]
[29200,40824,3402,40824,40800,-24]
[29300,40964,3413.6666666666665,40964,41000,36]
[29400,41104,3425.3333333333335,41104,41100,-4]
[29900,41803,3483.5833333333335,41803,41800,-3]
[30000,41942,3495.1666666666665,41942,41900,-42]
[30200,42222,3518.5,42222,42200,-22]
[30500,42641,3553.4166666666665,42641,42600,-41]
[30700,42921,3576.75,42921,42900,-21]
[30800,43061,3588.4166666666665,43061,43100,39]
[31800,44459,3704.9166666666665,44459,44500,41]
[32000,44739,3728.25,44739,44700,-39]
[32100,44878,3739.8333333333335,44878,44900,22]
[32500,45438,3786.5,{"$f":"B292","v":45438},45400,{"$f":"E292-D292","v":-38}]
[33000,46137,3844.75,46137,46100,-37]
[33300,46556,3879.6666666666665,46556,46600,44]
[34200,47814,3984.5,47814,47800,-14]
[34300,47954,3996.1666666666665,47954,48000,46]
[34700,48513,4042.75,48513,48500,-13]
[35000,48933,4077.75,{"$f":"B298","v":48933},48900,{"$f":"E298-D298","v":-33}]
[35100,49073,4089.4166666666665,49073,49100,27]
[35200,49212,4101,49212,49200,-12]
[35400,49492,4124.333333333333,49492,49500,8]
[36500,51030,4252.5,51030,51000,-30]
[36700,51309,4275.75,51309,51300,-9]
[37000,51729,4310.75,51729,51700,-29]
[38200,53407,4450.583333333333,53407,53400,-7]
[38900,54385,4532.083333333333,54385,54400,15]
[39200,54805,4567.083333333333,54805,54800,-5]
[40300,56343,4695.25,56343,56300,-43]
[40900,57181,4765.083333333333,57181,57200,19]
[41600,58160,{"$f":"VALUE(B310)/12","v":4846.666666666667},58160,58200,40]
[42000,58719,4893.25,58719,58700,-19]
[42700,59698,4974.833333333333,59698,{"$f":"IF(D312<1000,D312,ROUND(D312,-2))","v":59700},2]
[43300,60537,5044.75,60537,60500,-37]
[43500,60816,5068,60816,60800,-16]
[44000,61515,5126.25,61515,61500,-15]
[44100,61655,5137.916666666667,61655,61700,45]
[44900,62774,5231.166666666667,62774,62800,26]
[45700,63892,5324.333333333333,63892,63900,8]
[46000,64312,5359.333333333333,64312,64300,-12]
[46500,65011,5417.583333333333,65011,65000,-11]
[47000,{"$f":"IF(A321<1000,$B$1*A321,ROUND($B$1*A321,0))","v":65710},5475.833333333333,65710,65700,-10]
[47200,65989,5499.083333333333,65989,66000,11]
[47700,66688,5557.333333333333,66688,66700,12]
[48000,67108,5592.333333333333,67108,67100,-8]
[48600,67947,5662.25,67947,67900,-47]
[48800,68226,5685.5,68226,68200,-26]
[49900,69764,5813.666666666667,69764,69800,36]
[50000,69904,5825.333333333333,69904,69900,-4]
[51300,71721,5976.75,71721,71700,-21]
[52000,72700,6058.333333333333,72700,72700,0]
[53000,74098,6174.833333333333,74098,74100,2]
[53900,75356,6279.666666666667,75356,75400,44]
[55000,76894,6407.833333333333,76894,76900,6]
[56700,79271,6605.916666666667,79271,79300,29]
[56800,79411,6617.583333333333,79411,79400,-11]
[57000,79691,6640.916666666667,79691,79700,9]
[58700,82067,6838.916666666667,82067,82100,33]
[58800,82207,6850.583333333333,82207,82200,-7]
[59000,82487,6873.916666666667,82487,82500,13]
[59900,83745,6978.75,83745,83700,-45]
[60000,83885,6990.416666666667,83885,83900,15]
[62300,87100,7258.333333333333,87100,87100,0]
[63000,88079,7339.916666666667,88079,88100,21]
[63300,88498,7374.833333333333,88498,88500,2]
[63700,89058,7421.5,89058,89100,42]
[65000,90875,7572.916666666667,90875,90900,25]
[66100,92413,7701.083333333333,92413,92400,-13]
[67000,93671,7805.916666666667,93671,93700,29]
[69600,97306,8108.833333333333,97306,97300,-6]
[70400,98425,8202.0833333333339,98425,98400,-25]
[70800,98984,8248.6666666666661,98984,99000,16]
[71000,99264,8272,99264,99300,36]
[71700,100242,8353.5,100242,100200,-42]
[73400,102619,8551.5833333333339,102619,102600,-19]
[73500,102759,8563.25,102759,102800,41]
[78900,110308,9192.3333333333339,110308,110300,-8]
[80600,112685,9390.4166666666661,112685,112700,15]
[82200,114922,9576.8333333333339,114922,114900,-22]
[82600,115481,9623.4166666666661,115481,115500,19]
[82900,115901,9658.4166666666661,115901,115900,-1]
[83300,116460,9705,116460,116500,40]
[87000,121633,10136.083333333334,{"$f":"B362","v":121633},121600,{"$f":"E362-D362","v":-33}]
[88100,123171,10264.25,123171,123200,29]
[90600,126666,10555.5,126666,126700,34]
[93200,130301,10858.416666666666,130301,130300,-1]
[93900,131280,10940,131280,131300,20]
[94400,131979,10998.25,131979,132000,21]
[95300,133237,11103.083333333334,133237,133200,-37]
[96200,134495,11207.916666666666,134495,134500,5]
[102700,143583,11965.25,143583,143600,17]
[102800,143723,11976.916666666666,143723,143700,-23]
[104100,145540,12128.333333333334,145540,145500,-40]
[105600,147637,12303.083333333334,147637,147600,-37]
[106100,148336,{"$f":"VALUE(B374)/12","v":12361.333333333334},148336,148300,-36]
[109400,152950,12745.833333333334,152950,153000,50]
[110000,153789,12815.75,153789,{"$f":"IF(D376<1000,D376,ROUND(D376,-2))","v":153800},11]
[116200,162457,13538.083333333334,162457,162500,43]
[117300,163995,13666.25,163995,164000,5]
[117400,164134,13677.833333333334,164134,164100,-34]
[118000,164973,13747.75,164973,165000,27]
[118300,165393,13782.75,165393,165400,7]
[123400,172523,14376.916666666666,172523,172500,-23]
[124700,174340,14528.333333333334,174340,174300,-40]
[127100,177696,14808,177696,177700,4]
[129100,{"$f":"IF(A385<1000,$B$1*A385,ROUND($B$1*A385,0))","v":180492},15041,180492,180500,8]
[129800,181471,15122.583333333334,181471,181500,29]
[130900,183009,15250.75,183009,183000,-9]
[131900,184407,15367.25,184407,184400,-7]
[133400,186504,15542,186504,186500,-4]
[139400,194892,16241,194892,194900,8]
[140900,196989,16415.75,196989,197000,11]
[141600,197968,16497.333333333332,197968,198000,32]
[145000,202721,16893.416666666668,202721,202700,-21]
[146600,204958,17079.833333333332,204958,205000,42]
[147700,206496,17208,206496,206500,4]

{"sheet":"reguleringsprocenter","index":1,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Reguleringsprocenter",null,"pensionsudbygning"]
[null,"Valgt:",{"$f":"VLOOKUP(Forside!K11,reguleringsprocenter!B4:D15,2,TRUE)","v":1.1569700000000001}]
[null,"2020-01-01",1.045075,1]
[null,"2020-04-01",1.049075,1]
[null,"2020-10-01",1.0532239999999999,1]
[null,"2021-04-01",1.061123,1]
[null,"2021-10-01",1.0644739999999999,1]
[null,"2022-04-01",1.0644739999999999,1]
[null,"2022-10-01",1.083866,1]
[null,"2023-01-01",1.0919760000000001,1]
[null,"2023-10-01",1.0972200000000001,1]
[null,"2024-04-01",1.1411089999999999,1]
[null,"2024-10-01",1.1569700000000001,1]
[]
[]
[]
[null,"Liste, opslag niveauer"]
[]
[null,"2024-10-01"]
[null,"2024-04-01"]
[null,"2023-10-01"]
[null,"2023-01-01"]
[null,"2022-10-01"]
[null,"2022-04-01"]
[null,"2021-10-01"]
[null,"2021-04-01"]
[null,"2020-10-01"]
[null,"2020-04-01"]

{"sheet":"Lønark","index":2,"n_rows":70,"n_cols":120,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
["Næstved",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Løn","Årsløn",null,null,"Ureguleret ikke-pensionsgivende tillæg",null,null,null,"Årsløn ialt "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"trin","Grundsats","%-reg.","Sats","Omr 1","Omr 2","Omr 3","Omr 4",null,null,null,null,null,null,"Områdetillæg inkl. regulering",null,null,null,null,"Årsløn i alt ",null,null,null,null,null,"Pensionsgivende årsløn i alt ",null,null,null,null,"Pensionsgivende løn",null,null,null,null,null,null,null,null,"Pensionsgivende løn",null,null,null,null,null,"Løn","timelønninger",null,null,null,null,null,"Løn","timelønninger + 50%",null,null,null,null,null,"Løn","søndagstillæg - 50%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3441050000000001]
[null,"Månedsløn, løngrupper",null,null,"Lønniveau:",{"$f":"VLOOKUP(beregningsdato,regpct_tabel,1,TRUE)","v":"2024-10-01"},null,"Optrapning fra:",null,null,null,null,"Pensionsgivende løn",null,null,null,null,null,"Pensionsgivende løn, optrapning fra:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,null,"Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"Omr 0","Omr 1","Omr 2","Omr 3","Omr 4","Grundsats","%-reg.","Sats",null,"Pensionsudbygningspct:",null,null,{"$f":"VLOOKUP(F3,regpct_tabel,3,FALSE)","v":1},null,"Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"trin","Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"trin","Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"trin","Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"niveau","kolonne",null,"2017-10-01",null,null,null,"2018-10-01"]
[null,0,1,2,3,4,null,"0->1","1->2","2->3",null,null,0,1,2,3,4,null,"0->1","1->2","2->3","3->4",null,null,{"$f":"VLOOKUP(beregningsdato,Lønprojekt_DR,2,TRUE)","v":1339},{"$f":"valgt_regulering-1","v":0.15697000000000005},"2019-04-01","2022-04-01",{"$f":"VLOOKUP(beregningsdato,Lønprojekt_DR,3,TRUE)","v":620},4,5,null,null,null,null,null,null,{"$f":"IF(beregningsdato<40087,0,regulering)","v":0.15697000000000005},{"$f":"IF(beregningsdato<40087,0,5)","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-10-01","2018-10-01","2019-04-01",null,"omr1","omr2","omr3","omr4","omr5",null,null,null,"2017-10-01",2,null,"omr1","omr2","omr3","omr4","omr1","omr2","omr3","omr4",null,null,null,null,"2015-01-01",0,0]
[1,{"$f":"AQ5/12","v":19075},19344,19530.25,19799.416666666668,19985.666666666668,null,{"$f":"ROUND(AQ5+(AR5-AQ5)/3*faktor,0)/12","v":533223.66666666663},{"$f":"ROUND(AR5+(AS5-AR5)/3*faktor,0)/12","v":375329.83333333331},{"$f":"ROUND(AS5+(AT5-AS5)/3*faktor,0)/12","v":533997.5},null,1,{"$f":"B5","v":19075},{"$f":"C5","v":19344},{"$f":"D5","v":19530.25},{"$f":"E5","v":19799.416666666668},{"$f":"F5","v":19985.666666666668},null,{"$f":"(BK5+ROUND((BL5-BK5)/3*faktor,0))/12","v":514148.66666666669},{"$f":"(BL5+ROUND((BM5-BL5)/3*faktor,0))/12","v":356254.83333333331},{"$f":"(BM5+ROUND((BN5-BM5)/3*faktor,0))/12","v":514922.5},{"$f":"(BN5+ROUND((BO5-BN5)/3*faktor,0))/12","v":356710.25},null,1,197844,{"$f":"ROUND(Y5*regulering,0)","v":31056},{"$f":"Y5+Z5","v":228900},2790,4722,7514,9445,null,2076,3513,5590,7027,null,{"$f":"ROUND(AB5*(1+$AL$4),0)","v":3228},{"$f":"ROUND(AC5*(1+$AL$4),0)","v":5463},8693,10928,1,{"$f":"$AA5","v":228900},{"$f":"$AA5+AL5","v":232128},{"$f":"$AA5+AM5","v":234363},237593,239828,1,{"$f":"AQ5","v":228900},{"$f":"AR5","v":232128},{"$f":"AS5","v":234363},{"$f":"AT5","v":237593},{"$f":"AU5","v":239828},null,null,null,null,{"$f":"ROUND(AL5*udbygningspct,0)","v":3228},{"$f":"ROUND(AM5*udbygningspct,0)","v":5463},{"$f":"ROUND(AN5*udbygningspct,0)","v":8693},{"$f":"ROUND(AO5*udbygningspct,0)","v":10928},null,{"$f":"BD5","v":0},{"$f":"$BK5+BF5","v":3228},{"$f":"$BK5+BG5","v":5463},{"$f":"$BK5+BH5","v":8693},{"$f":"$BK5+BI5","v":10928},null,1,{"$f":"AQ5/1924","v":118.97089397089397},{"$f":"AR5/1924","v":120.64864864864865},{"$f":"AS5/1924","v":121.81029106029106},{"$f":"AT5/1924","v":123.48908523908524},{"$f":"AU5/1924","v":124.65072765072765},null,1,{"$f":"AQ5/1924*1.5","v":178.45634095634097},{"$f":"AR5/1924*1.5","v":180.97297297297297},{"$f":"AS5/1924*1.5","v":182.71543659043658},{"$f":"AT5/1924*1.5","v":185.23362785862787},{"$f":"AU5/1924*1.5","v":186.97609147609148},null,1,{"$f":"AQ5/1924/2","v":59.485446985446984},{"$f":"AR5/1924/2","v":60.324324324324323},{"$f":"AS5/1924/2","v":60.905145530145532},{"$f":"AT5/1924/2","v":61.744542619542621},{"$f":"AU5/1924/2","v":62.325363825363823},null,1,147194,197844,197844,4004,201848,2585,4374,6959,8748,null,null,null,"2018-10-01",3,1,2076,3513,5590,7027,{"$f":"ROUND(DB5*$DB$2,0)","v":2790},{"$f":"ROUND(DC5*$DB$2,0)","v":4722},{"$f":"ROUND(DD5*$DB$2,0)","v":7514},{"$f":"ROUND(DE5*$DB$2,0)","v":9445},null,147194,{"$f":"ROUND(DK5*$DB$2,0)","v":197844},null,"2019-04-01",719,0]
[2,19368,19643.666666666668,19834.333333333332,20110,20300.833333333332,null,546258.91666666663,384071.25,546725.25,null,2,{"$f":"B6","v":19368},19643.666666666668,19834.333333333332,20110,20300.833333333332,null,526890.91666666663,364703.25,527357.25,365488.08333333331,null,2,200883,{"$f":"ROUND(Y6*regulering,0)","v":31533},232416,2859,4837,7696,9675,null,2127,3599,5726,7198,null,{"$f":"ROUND(AB6*(1+$AL$4),0)","v":3308},{"$f":"ROUND(AC6*(1+$AL$4),0)","v":5596},{"$f":"ROUND(AD6*(1+$AL$4),0)","v":8904},{"$f":"ROUND(AE6*(1+$AL$4),0)","v":11194},2,{"$f":"$AA6","v":232416},{"$f":"$AA6+AL6","v":235724},238012,241320,243610,2,{"$f":"AQ6","v":232416},235724,238012,241320,243610,null,null,null,null,3308,5596,8904,11194,null,0,3308,5596,8904,11194,null,2,120.79833679833679,122.51767151767152,123.70686070686071,125.42619542619542,126.61642411642411,null,2,181.19750519750519,183.77650727650729,185.56029106029106,188.13929313929313,189.92463617463616,null,2,60.399168399168396,61.258835758835758,61.853430353430355,62.71309771309771,63.308212058212057,null,2,149455,200883,200883,4065,204948,2648,4481,7128,8961,null,null,null,"2019-04-01",4,2,2127,3599,5726,7198,{"$f":"ROUND(DB6*$DB$2,0)","v":2859},4837,7696,9675,null,149455,{"$f":"ROUND(DK6*$DB$2,0)","v":200883},null,"2022-04-01",{"$f":"DO5+DP6","v":1339},620]
[3,19668.916666666668,19951.083333333332,20146.75,20428.916666666668,20624.5,null,558983.5,393935.33333333331,559461.33333333337,null,3,19668.916666666668,19951.083333333332,20146.75,20428.916666666668,20624.5,null,539314.58333333337,374266.41666666669,539792.41666666663,374584.91666666669,null,3,204004,32023,236027,2927,4956,7883,9911,null,2178,3687,5865,7374,null,3386,5734,9120,11467,3,236027,239413,241761,245147,247494,3,236027,239413,241761,245147,247494,null,null,null,null,3386,5734,9120,11467,null,0,3386,5734,9120,11467,null,3,122.67515592515592,124.43503118503118,125.6554054054054,127.41528066528066,128.63513513513513,null,3,184.01273388773387,186.65254677754677,188.4831081081081,191.122920997921,192.95270270270271,null,3,61.33757796257796,62.217515592515589,62.827702702702702,63.707640332640331,64.317567567567565,null,3,151777,204004,204004,4129,208133,2711,4590,7301,9180,null,null,null,null,null,3,2178,3687,5865,7374,2927,4956,7883,9911,null,151777,204004]
[4,19978.083333333332,20267.333333333332,20467.666666666668,20756.916666666668,20957.166666666668,null,572831.25,403171.08333333331,573320.83333333337,null,4,19978.083333333332,20267.333333333332,20467.666666666668,20756.916666666668,20957.166666666668,null,552853.16666666663,383193,553342.75,383523.33333333331,null,4,207211,32526,239737,3000,5078,8078,10155,null,2232,3778,6010,7555,null,3471,5875,9346,11749,4,239737,243208,245612,249083,251486,4,239737,243208,245612,249083,251486,null,null,null,null,3471,5875,9346,11749,null,0,3471,5875,9346,11749,null,4,124.60343035343035,126.4074844074844,127.65696465696466,129.46101871101871,130.70997920997922,null,4,186.90514553014555,189.61122661122661,191.485446985447,194.19152806652806,196.06496881496884,null,4,62.301715176715177,63.203742203742202,63.82848232848233,64.730509355509355,65.354989604989612,null,4,154163,207211,207211,4194,211405,2779,4703,7482,9405,null,null,null,null,null,4,2232,3778,6010,7555,3000,5078,8078,10155,null,154163,207211]
[5,20295.75,20592.166666666668,20797.416666666668,21093.75,21298.75,null,586846.83333333337,412893.33333333331,587189.16666666663,null,5,20295.75,20592.166666666668,20797.416666666668,21093.75,21298.75,null,566551.08333333337,392597.58333333331,566893.41666666663,392621.33333333331,null,5,210506,33043,243549,3074,5203,8277,10403,null,2287,3871,6158,7740,null,3557,6020,9576,12036,5,243549,247106,249569,253125,255585,5,243549,247106,249569,253125,255585,null,null,null,null,3557,6020,9576,12036,null,0,3557,6020,9576,12036,null,5,126.58471933471934,128.43347193347194,129.71361746361745,131.56185031185032,132.84043659043658,null,5,189.877079002079,192.6502079002079,194.57042619542619,197.34277546777548,199.26065488565487,null,5,63.292359667359669,64.216735966735968,64.856808731808727,65.780925155925161,66.420218295218291,null,5,156614,210506,210506,4260,214766,2847,4819,7666,9636,null,null,null,null,null,5,2287,3871,6158,7740,3074,5203,8277,10403,null,156614,210506]
[6,20622.416666666668,20926,21136.416666666668,21440,21650.166666666668,null,600871.33333333337,423102.41666666669,601385.33333333337,null,6,20622.416666666668,20926,21136.416666666668,21440,21650.166666666668,null,580248.91666666663,402480,580762.91666666663,402516.16666666669,null,6,213894,33575,247469,3149,5331,8480,10660,null,2343,3966,6309,7931,null,3643,6168,9811,12333,6,247469,251112,253637,257280,259802,6,247469,251112,253637,257280,259802,null,null,null,null,3643,6168,9811,12333,null,0,3643,6168,9811,12333,null,6,128.62214137214139,130.51559251559252,131.82796257796258,133.72141372141371,135.03222453222452,null,6,192.93321205821206,195.77338877338877,197.74194386694387,200.58212058212058,202.54833679833678,null,6,64.311070686070693,65.257796257796258,65.91398128898129,66.860706860706856,67.516112266112259,null,6,159135,213894,213894,4329,218223,2917,4937,7854,9873,null,null,null,null,null,6,2343,3966,6309,7931,3149,5331,8480,10660,null,159135,213894]
[7,20957.583333333332,21268.75,21484.416666666668,21795.416666666668,22010.833333333332,null,615700.83333333337,433479.66666666669,615909.08333333337,null,7,20957.583333333332,21268.75,21484.416666666668,21795.416666666668,22010.833333333332,null,594743.25,412522.08333333331,594951.5,412570.91666666669,null,7,217370,34121,251491,3227,5464,8690,10924,null,2401,4065,6465,8127,null,3734,6322,10054,12639,7,251491,{"$f":"$AA11+AL11","v":255225},257813,261545,264130,7,251491,255225,257813,261545,264130,null,null,null,null,3734,6322,10054,12639,null,0,3734,6322,10054,12639,null,7,130.71257796257797,132.65332640332642,133.99844074844074,135.93814968814968,137.28170478170478,null,7,196.06886694386696,198.97998960498961,200.9976611226611,203.90722453222452,205.92255717255716,null,7,65.356288981288984,66.326663201663209,66.999220374220371,67.969074844074839,68.640852390852388,null,7,161721,217370,217370,4399,221769,2989,5060,8049,10118,null,null,null,null,null,7,2401,4065,6465,8127,3227,5464,8690,10924,null,161721,217370]
[8,21314.666666666668,21634,21855,22174.083333333332,22395.083333333332,null,631667.08333333337,444038.66666666669,631729.58333333337,null,8,21314.666666666668,21634,21855,22174.083333333332,22395.083333333332,null,610352.41666666663,422724,610414.91666666663,423264.08333333331,null,8,221074,34702,255776,3312,5604,8914,11206,null,2464,4169,6632,8337,null,3832,6484,10313,12965,8,255776,259608,262260,266089,268741,8,255776,259608,262260,266089,268741,null,null,null,null,3832,6484,10313,12965,null,0,3832,6484,10313,12965,null,8,132.93970893970894,134.93139293139293,136.30977130977132,138.29989604989606,139.67827442827442,null,8,199.40956340956342,202.39708939708942,204.46465696465697,207.44984407484409,209.51741164241162,null,8,66.469854469854468,67.465696465696467,68.154885654885661,69.149948024948031,69.83913721413721,null,8,164477,221074,221074,4474,225548,3067,5190,8256,10379,null,null,null,null,null,8,2464,4169,6632,8337,3312,5604,8914,11206,null,164477,221074]
[9,21985.25,22312.5,22538.916666666668,22866,23092.5,null,{"$f":"ROUND(AQ13+(AR13-AQ13)/3*faktor,0)/12","v":647469.08333333337},{"$f":"ROUND(AR13+(AS13-AR13)/3*faktor,0)/12","v":455070.25},{"$f":"ROUND(AS13+(AT13-AS13)/3*faktor,0)/12","v":647704.16666666663},null,9,21985.25,22312.5,22538.916666666668,22866,23092.5,null,{"$f":"(BK13+ROUND((BL13-BK13)/3*faktor,0))/12","v":625483.83333333337},{"$f":"(BL13+ROUND((BM13-BL13)/3*faktor,0))/12","v":433085},{"$f":"(BM13+ROUND((BN13-BM13)/3*faktor,0))/12","v":625718.91666666663},{"$f":"(BN13+ROUND((BO13-BN13)/3*faktor,0))/12","v":433797.75},null,9,228029,35794,263823,3394,5743,9135,11484,null,2525,4273,6796,8544,null,3927,6644,10569,13287,9,263823,267750,270467,274392,277110,9,263823,267750,270467,274392,277110,null,null,null,null,3927,6644,10569,13287,null,0,3927,6644,10569,13287,null,9,137.12214137214139,139.16320166320168,140.57536382536384,142.61538461538461,144.02806652806652,null,9,205.68321205821206,208.74480249480251,210.86304573804574,213.92307692307691,216.04209979209978,null,9,68.561070686070693,69.581600831600838,70.287681912681919,71.307692307692307,72.014033264033259,null,9,169651,228029,228029,4615,232644,3143,5319,8461,10637,null,null,null,null,null,9,2525,4273,6796,8544,3394,5743,9135,11484,null,169651,228029]
[10,22140.416666666668,22475.666666666668,22707.916666666668,23043.166666666668,23275.416666666668,null,662914.91666666663,466382.83333333331,663482.41666666663,null,10,22140.416666666668,22475.666666666668,22707.916666666668,23043.166666666668,23275.416666666668,null,640774.5,444242.41666666669,641342,444809.91666666669,null,10,229639,36046,265685,3477,5886,9363,11772,null,2587,4379,6966,8758,null,4023,6810,10833,13620,10,265685,269708,272495,276518,279305,10,265685,269708,272495,276518,279305,null,null,null,null,4023,6810,10833,13620,null,0,4023,6810,10833,13620,null,10,138.08991683991684,140.18087318087319,141.62941787941787,143.72037422037423,145.16891891891891,null,10,207.13487525987526,210.2713097713098,212.44412681912681,215.58056133056135,217.75337837837836,null,10,69.044958419958419,70.090436590436596,70.814708939708936,71.860187110187113,72.584459459459453,null,10,170849,229639,229639,4647,234286,3221,5451,8672,10903,null,null,null,null,null,10,2587,4379,6966,8758,3477,5886,9363,11772,null,170849,229639]
[11,22557,22900.75,23138.75,23482.25,23720.333333333332,null,679577.83333333337,477798.08333333331,679681.75,null,11,22557,22900.75,23138.75,23482.25,23720.333333333332,null,657020.83333333337,455241.08333333331,657124.75,455981.83333333331,null,11,232620,{"$f":"ROUND(IF(beregningsdato>=$AA$4,SUM(Y15,$Y$4)*regulering,Y15*regulering),0)","v":36725},{"$f":"IF(beregningsdato>=$AA$4,SUM($Y$4,Y15:Z15),SUM(Y15:Z15))","v":270684},3565,6034,9597,12066,null,2652,4489,7140,8977,null,4125,6981,11103,13960,11,{"$f":"$AA15","v":270684},274809,277665,281787,284644,11,270684,274809,277665,281787,284644,null,null,null,null,4125,6981,11103,13960,null,0,4125,6981,11103,13960,null,11,140.68814968814968,142.83212058212058,144.31652806652806,146.45893970893971,147.94386694386694,null,11,211.03222453222452,214.24818087318087,216.4747920997921,219.68840956340955,221.91580041580039,null,11,70.344074844074839,71.41606029106029,72.158264033264032,73.229469854469855,73.971933471933468,null,11,173067,232620,233339,4722,237342,3301,5588,8889,11175,null,null,null,null,null,11,2652,4489,7140,8977,3565,6034,9597,12066,null,173067,232620]
[12,22941.166666666668,23293.333333333332,23537.333333333332,23889.666666666668,24133.5,null,696049.08333333337,489658.66666666669,696963.75,null,12,22941.166666666668,23293.333333333332,23537.333333333332,23889.666666666668,24133.5,null,673107.91666666663,466717.5,674022.58333333337,466995.25,null,12,236605,37350,275294,3653,6183,9838,12367,null,2718,4600,7319,9201,null,4226,7154,11382,14308,12,275294,279520,282448,286676,289602,12,275294,279520,282448,286676,289602,null,null,null,null,4226,7154,11382,14308,null,0,4226,7154,11382,14308,null,12,143.08419958419958,145.28066528066529,146.80249480249481,149,150.52079002079003,null,12,214.62629937629936,217.92099792099793,220.20374220374219,223.5,225.78118503118503,null,12,71.542099792099791,72.640332640332645,73.401247401247403,74.5,75.260395010395015,null,12,176032,236605,237324,4803,241408,3384,5727,9112,11455,null,null,null,null,null,12,2718,4600,7319,9201,3653,6183,9838,12367,null,176032,236605]
[13,23336.333333333332,23697.5,23947.583333333332,24308.75,24558.833333333332,null,713646.25,501690.08333333331,714257.5,null,13,23336.333333333332,23697.5,23947.583333333332,24308.75,24558.833333333332,null,690309.91666666663,478353.75,690921.16666666663,478965,null,13,240704,37993,280036,3746,6340,10086,12680,null,2787,4717,7504,9434,null,4334,7335,11669,14670,13,280036,284370,287371,291705,294706,13,280036,284370,287371,291705,294706,null,null,null,null,4334,7335,11669,14670,null,0,4334,7335,11669,14670,null,13,145.54885654885655,147.80145530145529,149.36122661122661,151.61382536382536,153.17359667359668,null,13,218.32328482328484,221.70218295218294,224.04183991683993,227.42073804573803,229.76039501039503,null,13,72.774428274428274,73.900727650727646,74.680613305613306,75.806912681912678,76.586798336798338,null,13,179081,240704,241423,4886,245590,3470,5872,9342,11744,null,null,null,null,null,13,2787,4717,7504,9434,3746,6340,10086,12680,null,179081,240704]
[14,23742.333333333332,24112.583333333332,24368.916666666668,24739.25,24995.583333333332,null,731413.5,514051,732199.33333333337,null,14,23742.333333333332,24112.583333333332,24368.916666666668,24739.25,24995.583333333332,null,707671.16666666663,490308.66666666669,708457,490935.33333333331,null,14,244915,38654,284908,3840,6499,10340,12999,null,2857,4835,7693,9671,null,4443,7519,11963,15039,14,284908,289351,292427,296871,299947,14,284908,289351,292427,296871,299947,null,null,null,null,4443,7519,11963,15039,null,0,4443,7519,11963,15039,null,14,148.08108108108109,150.39033264033264,151.98908523908523,154.29885654885655,155.89760914760916,null,14,222.12162162162164,225.58549896049897,227.98362785862784,231.44828482328484,233.84641372141374,null,14,74.040540540540547,75.195166320166322,75.994542619542614,77.149428274428274,77.94880457380458,null,14,182214,244915,245634,4971,249886,3557,6019,9577,12039,null,null,null,null,null,14,2857,4835,7693,9671,3840,6499,10340,12999,null,182214,244915]
[15,24143.25,24522.833333333332,24785.75,25165.25,25428.166666666668,null,749653.5,527044.25,750136.75,null,15,24143.25,24522.833333333332,24785.75,25165.25,25428.166666666668,null,725510.25,502901,725993.5,503543.41666666669,null,15,249073,39307,289719,3937,6664,10600,13327,null,2929,4958,7886,9915,null,4555,7710,12264,15419,15,289719,294274,297429,301983,305138,15,289719,294274,297429,301983,305138,null,null,null,null,4555,7710,12264,15419,null,0,4555,7710,12264,15419,null,15,150.58160083160084,152.94906444906445,154.58887733887735,156.9558212058212,158.5956340956341,null,15,225.87240124740126,229.42359667359668,231.88331600831603,235.43373180873181,237.89345114345116,null,15,75.290800415800419,76.474532224532226,77.294438669438676,78.477910602910598,79.297817047817048,null,15,185308,249073,249792,5055,254128,3646,6172,9818,12343,null,null,null,null,null,15,2929,4958,7886,9915,3937,6664,10600,13327,null,185308,249073]
[16,24553.666666666668,24942.833333333332,25212.25,25601.416666666668,25871,null,768380.91666666663,539887.91666666663,769039.5,null,16,24553.666666666668,24942.833333333332,25212.25,25601.416666666668,25871,null,743827.25,515334.25,744485.83333333337,516311.33333333331,null,16,253330,39975,294644,4036,6831,10867,13663,null,3003,5082,8085,10165,null,4670,7903,12573,15808,16,294644,299314,302547,307217,310452,16,294644,299314,302547,307217,310452,null,null,null,null,4670,7903,12573,15808,null,0,4670,7903,12573,15808,null,16,153.14137214137213,155.56860706860707,157.24896049896049,159.67619542619542,161.35758835758836,null,16,229.7120582120582,233.35291060291058,235.87344074844071,239.51429313929313,242.03638253638252,null,16,76.570686070686065,77.784303534303533,78.624480249480243,79.83809771309771,80.678794178794178,null,16,188475,253330,254049,5141,258471,3738,6327,10065,12655,null,null,null,null,null,16,3003,5082,8085,10165,4036,6831,10867,13663,null,188475,253330]
[17,{"$f":"AQ21/12","v":24894.75},25295.583333333332,25573.333333333332,25974.166666666668,26251.666666666668,null,791020.83333333337,556168.41666666663,791699.41666666663,null,17,24894.75,25295.583333333332,25573.333333333332,25974.166666666668,26251.666666666668,null,766126.08333333337,531273.66666666663,766804.66666666663,531474.41666666663,null,17,256867,40531,298737,4157,7038,11196,14074,null,3093,5236,8330,10471,null,4810,8143,12953,16283,17,298737,303547,306880,311690,315020,17,298737,303547,306880,311690,315020,null,null,null,null,4810,8143,12953,16283,null,0,4810,8143,12953,16283,null,17,155.26871101871103,157.76871101871103,159.50103950103951,162.00103950103951,163.73180873180874,null,17,232.90306652806655,236.65306652806655,239.25155925155929,243.00155925155929,245.5977130977131,null,17,77.634355509355515,78.884355509355515,79.750519750519757,81.000519750519757,81.86590436590437,null,17,191106,256867,257586,5213,262080,3851,6518,10370,13035,null,null,null,null,null,17,3093,5236,8330,10471,4157,7038,11196,14074,null,191106,256867]
[18,25349.416666666668,25760.5,26045.083333333332,26456.25,26740.833333333332,null,811066.66666666663,569694.08333333337,811921.66666666663,null,18,25349.416666666668,25760.5,26045.083333333332,26456.25,26740.833333333332,null,785717.25,544344.66666666663,786572.25,545040.41666666663,null,18,261583,41271,304193,4264,7215,11480,14432,null,3172,5368,8541,10737,null,4933,8348,13282,16697,18,304193,309126,312541,317475,320890,18,304193,309126,312541,317475,320890,null,null,null,null,4933,8348,13282,16697,null,0,4933,8348,13282,16697,null,18,158.10446985446984,160.66839916839916,162.44334719334719,165.00779625779626,166.78274428274429,null,18,237.15670478170478,241.00259875259874,243.66502079002078,247.51169438669439,250.17411642411645,null,18,79.05223492723492,80.334199584199581,81.221673596673597,82.503898128898129,83.391372141372145,null,18,194615,261583,262302,5308,266891,3949,6683,10633,13367,null,null,null,null,null,18,3172,5368,8541,10737,4264,7215,11480,14432,null,194615,261583]
[19,25689.833333333332,26111.333333333332,26403.416666666668,26824.916666666668,27116.75,null,831316.83333333337,584379.91666666663,832030.41666666663,null,19,25689.833333333332,26111.333333333332,26403.416666666668,26824.916666666668,27116.75,null,805627,558690.08333333337,806340.58333333337,558925.83333333337,null,19,265114,41825,308278,4372,7401,11773,14800,null,3253,5506,8759,11011,null,5058,8563,13621,17123,19,308278,313336,316841,321899,{"$f":"$AA23+AO23","v":325401},19,308278,313336,316841,321899,325401,null,null,null,null,5058,8563,13621,17123,null,0,5058,8563,13621,17123,null,19,160.22765072765074,162.85654885654887,164.67827442827442,167.30717255717255,169.12733887733887,null,19,240.34147609147612,244.28482328482329,247.01741164241162,250.96075883575884,253.69100831600832,null,19,80.11382536382537,81.428274428274435,82.33913721413721,83.653586278586275,84.563669438669436,null,19,197242,265114,265833,5380,270494,4050,6854,10904,13708,null,null,null,null,null,19,3253,5506,8759,11011,4372,7401,11773,14800,null,197242,265114]
[20,25973.916666666668,26406.25,26705.416666666668,27137.916666666668,27437.083333333332,null,852307,598213.5,853357.08333333337,null,20,25973.916666666668,26406.25,26705.416666666668,27137.916666666668,27437.083333333332,null,826333.08333333337,572239.58333333337,827383.16666666663,572971.25,null,20,268779,{"$f":"ROUND(IF(beregningsdato>=$AB$4,SUM(Y24,$AC$4)*regulering,Y24*regulering),0)","v":42288},{"$f":"IF(beregningsdato>=$AB$4,SUM($AC$4,Y24:Z24),SUM(Y24:Z24))","v":311687},4484,7587,12073,15176,null,3336,5645,8982,11291,null,5188,8778,13968,17558,20,311687,316875,320465,325655,329245,20,311687,316875,320465,325655,329245,null,null,null,null,5188,8778,13968,17558,null,0,5188,8778,13968,17558,null,20,161.99948024948026,164.69594594594594,166.56185031185032,169.25935550935552,171.12525987525987,null,20,242.99922037422039,247.04391891891891,249.84277546777548,253.88903326403329,256.68788981288981,null,20,80.999740124740129,82.347972972972968,83.280925155925161,84.629677754677758,85.562629937629936,null,20,199969,268779,268779,5440,274219,4153,7028,11182,14056,null,null,null,null,null,20,3336,5645,8982,11291,4484,7587,12073,15176,null,199969,268779]
[21,26403.75,26847.083333333332,27154.083333333332,27597.416666666668,27904.416666666668,null,873761.5,613626.41666666663,874511.83333333337,null,21,26403.75,26847.083333333332,27154.083333333332,27597.416666666668,27904.416666666668,null,847357.75,587222.66666666663,848108.08333333337,587973,null,21,273238,{"$f":"ROUND(IF(beregningsdato>=$AB$4,SUM(Y25,$AC$4)*regulering,Y25*regulering),0)","v":42987},{"$f":"IF(beregningsdato>=$AB$4,SUM($AC$4,Y25:Z25),SUM(Y25:Z25))","v":316845},4598,7782,12381,15565,null,3421,5790,9211,11580,null,5320,9004,14324,18008,21,316845,322165,325849,331169,334853,21,316845,322165,325849,331169,334853,null,null,null,null,5320,9004,14324,18008,null,0,5320,9004,14324,18008,null,21,164.68035343035342,167.44542619542619,169.3601871101871,172.12525987525987,174.04002079002078,null,21,247.02053014553013,251.16813929313929,254.04028066528065,258.18788981288981,261.06003118503116,null,21,82.34017671517671,83.722713097713097,84.680093555093549,86.062629937629936,87.020010395010388,null,21,203286,273238,273238,5530,278768,4259,7208,11467,14416,null,null,null,null,null,21,3421,5790,9211,11580,4598,7782,12381,15565,null,203286,273238]
[22,26802.333333333332,27245.666666666668,27552.666666666668,27996,28303,null,874160.08333333337,614025,874910.41666666663,null,22,26802.333333333332,27245.666666666668,27552.666666666668,27996,28303,null,847357.75,587222.66666666663,848108.08333333337,587973,null,22,277372,{"$f":"ROUND(IF(beregningsdato>=$AB$4,SUM(Y26,$AC$4)*regulering,Y26*regulering),0)","v":43636},{"$f":"IF(beregningsdato>=$AB$4,SUM($AC$4,Y26:Z26),SUM(Y26:Z26))","v":321628},4598,7782,12381,15565,null,3421,5790,9211,11580,null,5320,9004,14324,18008,22,321628,326948,330632,335952,339636,22,321628,326948,330632,335952,339636,null,null,null,null,5320,9004,14324,18008,null,0,5320,9004,14324,18008,null,22,167.16632016632016,169.93139293139293,171.84615384615384,174.61122661122661,176.52598752598752,null,22,250.74948024948026,254.89708939708942,257.76923076923077,261.91683991683993,264.78898128898129,null,22,83.583160083160081,84.965696465696467,85.92307692307692,87.305613305613306,88.262993762993759,null,22,206362,277372,277372,5613,282985,4259,7208,11467,14416,null,null,null,null,null,22,3421,5790,9211,11580,4598,7782,12381,15565,null,206362,277372]
[23,27169.166666666668,27600.583333333332,27898.916666666668,28330.166666666668,28628.75,null,851750.25,597815,852161.41666666663,null,23,27169.166666666668,27600.583333333332,27898.916666666668,28330.166666666668,28628.75,null,824581.08333333337,570645.83333333337,824992.25,571853.25,null,23,281796,{"$f":"ROUND(Y27*regulering,0)","v":44234},{"$f":"Y27+Z27","v":326030},4475,7569,12042,15139,null,3329,5631,8959,11263,null,5177,8757,13932,17515,23,326030,331207,334787,339962,343545,23,326030,331207,334787,339962,343545,null,null,null,null,5177,8757,13932,17515,null,0,5177,8757,13932,17515,null,23,169.45426195426197,172.14501039501039,174.00571725571726,176.69542619542619,178.55769230769232,null,23,254.18139293139296,258.21751559251561,261.00857588357587,265.04313929313929,267.83653846153845,null,23,84.727130977130983,86.072505197505194,87.002858627858629,88.347713097713097,89.27884615384616,null,23,209653,281796,281796,5703,287499,4144,7010,11153,14021,null,null,null,null,null,23,3329,5631,8959,11263,4475,7569,12042,15139,null,209653,281796]
[24,27609.166666666668,28028.083333333332,28318.333333333332,28737.25,29027.333333333332,null,828298.58333333337,582792.58333333337,829007.75,null,24,27609.166666666668,28028.083333333332,28318.333333333332,28737.25,29027.333333333332,null,800689.41666666663,555183.41666666663,801398.58333333337,555574,null,24,286360,44950,331310,4345,7355,11700,14709,null,3233,5472,8705,10943,null,5027,8510,13537,17018,24,331310,336337,339820,344847,348328,24,331310,336337,339820,344847,348328,null,null,null,null,5027,8510,13537,17018,null,0,5027,8510,13537,17018,null,24,172.19854469854471,174.81133056133055,176.62162162162161,179.23440748440748,181.04365904365903,null,24,258.29781704781703,262.21699584199581,264.93243243243239,268.85161122661123,271.56548856548852,null,24,86.099272349272354,87.405665280665275,88.310810810810807,89.617203742203742,90.521829521829517,null,24,213049,286360,286360,5795,292155,4025,6812,10837,13623,null,null,null,null,null,24,3233,5472,8705,10943,4345,7355,11700,14709,null,213049,286360]
[25,28058.416666666668,28464.333333333332,28745.25,29151.333333333332,{"$f":"AU29/12","v":29432.333333333332},null,803900.5,565389.75,804905.83333333337,null,25,28058.416666666668,28464.333333333332,28745.25,29151.333333333332,29432.333333333332,null,775842.08333333337,537331.33333333337,776847.41666666663,538177.58333333337,null,25,291020,45681,336701,4210,7124,11336,14250,null,3132,5300,8434,10602,null,4871,8242,13115,16487,25,336701,341572,344943,349816,353188,25,336701,341572,344943,349816,353188,null,null,null,null,4871,8242,13115,16487,null,0,4871,8242,13115,16487,null,25,175.00051975051974,177.53222453222452,179.28430353430355,181.81704781704781,183.56964656964658,null,25,262.50077962577961,266.29833679833678,268.92645530145535,272.72557172557174,275.35446985446987,null,25,87.500259875259871,88.766112266112259,89.642151767151773,90.908523908523904,91.78482328482329,null,25,216516,291020,291020,5890,296910,3899,6598,10499,13198,null,null,null,null,null,25,3132,5300,8434,10602,4210,7124,11336,14250,null,216516,291020]
[26,28518.166666666668,28910.166666666668,29181.416666666668,29573.416666666668,29844.666666666668,null,777760.83333333337,547359.33333333337,778424.08333333337,null,26,28518.166666666668,28910.166666666668,29181.416666666668,29573.416666666668,29844.666666666668,null,749242.66666666663,518841.16666666669,749905.91666666663,519504.41666666669,null,26,295788,46430,342218,4066,6879,10945,13758,null,3025,5118,8143,10236,null,4704,7959,12663,15918,26,342218,346922,350177,354881,358136,26,342218,346922,350177,354881,358136,null,null,null,null,4704,7959,12663,15918,null,0,4704,7959,12663,15918,null,26,177.86798336798336,180.31288981288981,182.00467775467774,184.44958419958419,186.14137214137213,null,26,266.80197505197503,270.46933471933471,273.00701663201664,276.67437629937626,279.2120582120582,null,26,88.933991683991678,90.156444906444904,91.002338877338872,92.224792099792097,93.070686070686065,null,26,220063,295788,295788,5986,301774,3766,6372,10137,12743,null,null,null,null,null,26,3025,5118,8143,10236,4066,6879,10945,13758,null,220063,295788]
[27,28988.25,29365.25,29626.166666666668,30002.916666666668,30263.833333333332,null,749560.91666666663,528064,749721,null,27,28988.25,29365.25,29626.166666666668,30002.916666666668,30263.833333333332,null,720572.66666666663,499075.75,720732.75,499713.41666666669,null,27,300664,47195,347859,3910,6616,10524,13230,null,2909,4922,7830,9843,null,4524,7655,12176,15307,27,347859,352383,355514,360035,363166,27,347859,352383,355514,360035,363166,null,null,null,null,4524,7655,12176,15307,null,0,4524,7655,12176,15307,null,27,180.79989604989606,183.15124740124739,184.77858627858629,187.12837837837839,188.75571725571726,null,27,271.19984407484412,274.7268711018711,277.16787941787942,280.69256756756761,283.13357588357587,null,27,90.399948024948031,91.575623700623694,92.389293139293144,93.564189189189193,94.377858627858629,null,27,223691,300664,300664,6085,306749,3621,6127,9748,12254,null,null,null,null,null,27,2909,4922,7830,9843,3910,6616,10524,13230,null,223691,300664]
[28,29468.833333333332,29829.75,30079.583333333332,30440.5,30690.166666666668,null,719300.91666666663,507344.5,719911.66666666663,null,28,29468.833333333332,29829.75,30079.583333333332,30440.5,30690.166666666668,null,689832.08333333337,477875.66666666669,690442.83333333337,478167.91666666669,null,28,305648,47978,353626,3743,6335,10078,12668,null,2785,4713,7498,9425,null,4331,7329,11660,14656,28,353626,357957,360955,365286,368282,28,353626,357957,360955,365286,368282,null,null,null,null,4331,7329,11660,14656,null,0,4331,7329,11660,14656,null,28,183.79729729729729,186.04833679833681,187.60654885654887,189.85758835758836,191.4147609147609,null,28,275.69594594594594,279.07250519750522,281.40982328482329,284.78638253638252,287.12214137214136,null,28,91.898648648648646,93.024168399168403,93.803274428274435,94.928794178794178,95.707380457380452,null,28,227399,305648,305648,6186,311834,3467,5867,9334,11733,null,null,null,null,null,28,2785,4713,7498,9425,3743,6335,10078,12668,null,227399,305648]
[29,29960.25,30304.083333333332,30542,30885.833333333332,31123.833333333332,null,687140.33333333337,485042.16666666669,687722.08333333337,null,29,29960.25,30304.083333333332,30542,30885.833333333332,31123.833333333332,null,657180.08333333337,455081.91666666669,657761.83333333337,455822.91666666669,null,29,310745,48778,359523,3566,6034,9600,12069,null,2653,4489,7142,8979,null,4126,6981,11107,13963,29,359523,363649,366504,370630,373486,29,359523,363649,366504,370630,373486,null,null,null,null,4126,6981,11107,13963,null,0,4126,6981,11107,13963,null,29,186.8622661122661,189.00675675675674,190.49064449064448,192.63513513513513,194.11954261954261,null,29,280.29339916839916,283.5101351351351,285.73596673596671,288.95270270270271,291.17931392931393,null,29,93.431133056133049,94.503378378378372,95.245322245322242,96.317567567567565,97.059771309771307,null,29,231191,310745,310745,6289,317034,3303,5589,8891,11178,null,null,null,null,null,29,2653,4489,7142,8979,3566,6034,9600,12069,null,231191,310745]
[30,30462.25,30787.75,31013.25,31338.833333333332,31564.166666666668,null,652601.25,461793.41666666669,653311.5,null,30,30462.25,30787.75,31013.25,31338.833333333332,31564.166666666668,null,622139,431331.16666666669,622849.25,431563.66666666669,null,30,315952,49595,365547,3376,5715,9092,11429,null,2512,4252,6764,8503,null,3906,6612,10519,13223,30,365547,369453,372159,376066,378770,30,365547,369453,372159,376066,378770,null,null,null,null,3906,6612,10519,13223,null,0,3906,6612,10519,13223,null,30,189.99324324324326,192.02338877338877,193.42983367983368,195.46049896049897,196.86590436590436,null,30,284.9898648648649,288.03508316008316,290.14475051975052,293.19074844074845,295.29885654885652,null,30,94.996621621621628,96.011694386694387,96.714916839916839,97.730249480249483,98.432952182952178,null,30,235065,315952,315952,6394,322346,3127,5293,8420,10585,null,null,null,null,null,30,2512,4252,6764,8503,3376,5715,9092,11429,null,235065,315952]
[31,30975.666666666668,31281.916666666668,31493.916666666668,31800.083333333332,32012,null,616321.5,436484.58333333331,616680.5,null,31,30975.666666666668,31281.916666666668,31493.916666666668,31800.083333333332,32012,null,585345.83333333337,405508.91666666669,585704.83333333337,405867.83333333331,null,31,321277,50431,371708,3176,5375,8551,10749,null,2363,3999,6362,7997,null,3675,6219,9893,12436,31,371708,375383,377927,381601,384144,31,371708,375383,377927,381601,384144,null,null,null,null,3675,6219,9893,12436,null,0,3675,6219,9893,12436,null,31,193.19542619542619,195.10550935550935,196.42775467775468,198.3373180873181,199.65904365904365,null,31,289.79313929313929,292.658264033264,294.641632016632,297.50597713097716,299.48856548856548,null,31,96.597713097713097,97.552754677754677,98.213877338877339,99.168659043659048,99.829521829521823,null,31,239027,321277,321277,6502,327779,2942,4978,7920,9956,null,null,null,null,null,31,2363,3999,6362,7997,3176,5375,8551,10749,null,239027,321277]
[32,31500.5,31786,31983.75,32269.5,32467.166666666668,null,577186.16666666663,409752.16666666669,578147.25,null,32,31500.5,31786,31983.75,32269.5,32467.166666666668,null,545685.66666666663,378251.66666666669,546646.75,378575.91666666669,null,32,326721,51285,378006,2961,5012,7976,10026,null,2203,3729,5934,7459,null,3426,5799,9228,11600,32,378006,381432,383805,387234,389606,32,378006,381432,383805,387234,389606,null,null,null,null,3426,5799,9228,11600,null,0,3426,5799,9228,11600,null,32,196.46881496881497,198.24948024948026,199.48284823284823,201.26507276507277,202.497920997921,null,32,294.70322245322245,297.37422037422039,299.22427234927233,301.89760914760916,303.74688149688149,null,32,98.234407484407484,99.124740124740129,99.741424116424113,100.63253638253639,101.2489604989605,null,32,243077,326721,326721,6612,333333,2743,4642,7387,9286,null,null,null,null,null,32,2203,3729,5934,7459,2961,5012,7976,10026,null,243077,326721]
[33,32036.75,32300.416666666668,32483.083333333332,32746.916666666668,32929.333333333336,null,535991.66666666663,381437.33333333331,536756.5,null,33,32036.75,32300.416666666668,32483.083333333332,32746.916666666668,32929.333333333336,null,503954.91666666669,349400.58333333331,504719.75,349369.25,null,33,332283,52158,384441,2735,4629,7366,9258,null,2035,3444,5480,6888,null,3164,5356,8522,10711,33,384441,387605,389797,392963,395152,33,384441,387605,389797,392963,395152,null,null,null,null,{"$f":"ROUND(AL37*udbygningspct,0)","v":3164},{"$f":"ROUND(AM37*udbygningspct,0)","v":5356},{"$f":"ROUND(AN37*udbygningspct,0)","v":8522},{"$f":"ROUND(AO37*udbygningspct,0)","v":10711},null,{"$f":"BD37","v":0},{"$f":"$BK37+BF37","v":3164},{"$f":"$BK37+BG37","v":5356},{"$f":"$BK37+BH37","v":8522},{"$f":"$BK37+BI37","v":10711},null,33,{"$f":"AQ37/1924","v":199.81340956340955},{"$f":"AR37/1924","v":201.4579002079002},{"$f":"AS37/1924","v":202.59719334719335},{"$f":"AT37/1924","v":204.24272349272348},{"$f":"AU37/1924","v":205.38045738045739},null,33,{"$f":"AQ37/1924*1.5","v":299.72011434511433},{"$f":"AR37/1924*1.5","v":302.18685031185032},{"$f":"AS37/1924*1.5","v":303.89579002079006},{"$f":"AT37/1924*1.5","v":306.36408523908523},{"$f":"AU37/1924*1.5","v":308.07068607068607},null,33,{"$f":"AQ37/1924/2","v":99.906704781704775},{"$f":"AR37/1924/2","v":100.7289501039501},{"$f":"AS37/1924/2","v":101.29859667359668},{"$f":"AT37/1924/2","v":102.12136174636174},{"$f":"AU37/1924/2","v":102.69022869022869},null,33,247215,332283,332283,6725,339008,2534,4288,6822,8575,null,null,null,null,null,33,2035,3444,5480,6888,2735,4629,7366,9258,null,247215,332283]
[34,32585.5,32826.083333333336,32992.666666666664,33233.25,33399.833333333336,null,492420.41666666669,351222.33333333331,492827.58333333331,null,34,32585.5,32826.083333333336,32992.666666666664,33233.25,33399.833333333336,null,459834.91666666669,318636.83333333331,460242.08333333331,319044,null,34,337974,53052,391026,2495,4223,6718,8446,null,1856,3142,4998,6284,null,2887,4886,7773,9772,34,391026,393913,395912,398799,400798,34,391026,393913,395912,398799,400798,null,null,null,null,2887,4886,7773,9772,null,0,2887,4886,7773,9772,null,34,203.23596673596674,204.73648648648648,205.77546777546777,207.27598752598752,208.31496881496881,null,34,304.85395010395013,307.10472972972974,308.66320166320168,310.91398128898129,312.47245322245323,null,34,101.61798336798337,102.36824324324324,102.88773388773389,103.63799376299376,104.1574844074844,null,34,251449,337974,337974,6840,344814,2311,3911,6222,7823,null,null,null,null,null,34,1856,3142,4998,6284,2495,4223,6718,8446,null,251449,337974]
[35,33145.666666666664,33361.833333333336,33511.25,33727.166666666664,33876.75,null,446312.25,318946.91666666669,446200,null,35,33145.666666666664,33361.833333333336,33511.25,33727.166666666664,33876.75,null,413166.58333333331,285801.25,413054.33333333331,286485.08333333331,null,35,343784,53964,397748,2242,3792,6031,7583,null,1668,2821,4487,5642,null,2594,4387,6978,8773,35,397748,400342,402135,404726,406521,35,397748,400342,402135,404726,406521,null,null,null,null,2594,4387,6978,8773,null,0,2594,4387,6978,8773,null,35,206.72972972972974,208.07796257796258,209.00987525987526,210.35654885654887,211.28950103950103,null,35,310.09459459459458,312.11694386694387,313.5148128898129,315.53482328482329,316.93425155925155,null,35,103.36486486486487,104.03898128898129,104.50493762993763,105.17827442827443,105.64475051975052,null,35,255772,343784,343784,6958,350742,2076,3512,5586,7024,null,null,null,null,null,35,1668,2821,4487,5642,2242,3792,6031,7583,null,255772,343784]
[36,33718.75,33908.916666666664,34040.25,34230.25,34361.75,null,397190.66666666669,284930.66666666669,397193.58333333331,null,36,33718.75,33908.916666666664,34040.25,34230.25,34361.75,null,363471.91666666669,251211.91666666666,363474.83333333331,251851.83333333334,null,36,349728,54897,404625,1972,3335,5305,6669,null,1467,2481,3947,4962,null,2282,3858,6138,7716,36,404625,406907,408483,410763,412341,36,404625,406907,408483,410763,412341,null,null,null,null,2282,3858,6138,7716,null,0,2282,3858,6138,7716,null,36,210.30405405405406,211.49012474012474,212.30925155925155,213.49428274428274,214.31444906444906,null,36,315.45608108108109,317.2351871101871,318.4638773388773,320.24142411642413,321.47167359667361,null,36,105.15202702702703,105.74506237006237,106.15462577962577,106.74714137214137,107.15722453222453,null,36,260194,349728,349728,7078,356806,1826,3089,4914,6177,null,null,null,null,null,36,1467,2481,3947,4962,1972,3335,5305,6669,null,260194,349728]
[37,34304.25,34466.583333333336,34579.25,34741.583333333336,34854.083333333336,null,344577.33333333331,249810.16666666666,344852.33333333331,null,37,34304.25,34466.583333333336,34579.25,34741.583333333336,34854.083333333336,null,310273.08333333331,215505.91666666666,310548.08333333331,215462.33333333334,null,37,355801,55850,411651,1684,2852,4536,5703,null,1253,2122,3375,4243,null,1948,3300,5248,6598,37,411651,413599,414951,416899,418249,37,411651,413599,414951,416899,418249,null,null,null,null,1948,3300,5248,6598,null,0,1948,3300,5248,6598,null,37,213.9558212058212,214.96829521829522,215.67099792099793,216.68347193347194,217.38513513513513,null,37,320.93373180873181,322.45244282744284,323.5064968814969,325.02520790020787,326.07770270270271,null,37,106.9779106029106,107.48414760914761,107.83549896049897,108.34173596673597,108.69256756756756,null,37,264712,355801,355801,7201,363002,1560,2642,4202,5282,null,null,null,null,null,37,1253,2122,3375,4243,1684,2852,4536,5703,null,264712,355801]
[38,34925.75,35061.666666666664,35155.916666666664,35291.833333333336,35386.25,null,294707.83333333331,215204.83333333334,294938,null,38,34925.75,35061.666666666664,35155.916666666664,35291.833333333336,35386.25,null,259782.08333333334,180279.08333333334,260012.25,180827.83333333334,null,38,362247,56862,419109,1410,2387,3797,4776,null,1049,1776,2825,3553,null,1631,2762,4393,5526,38,419109,420740,421871,423502,424635,38,419109,420740,421871,423502,424635,null,null,null,null,1631,2762,4393,5526,null,0,1631,2762,4393,5526,null,38,217.83212058212058,218.67983367983368,219.26767151767152,220.11538461538461,220.70426195426197,null,38,326.7481808731809,328.01975051975052,328.90150727650729,330.17307692307691,331.05639293139296,null,38,108.91606029106029,109.33991683991684,109.63383575883576,110.05769230769231,110.35213097713098,null,38,269508,362247,362247,7331,369578,1306,2211,3517,4423,null,null,null,null,null,38,1049,1776,2825,3553,1410,2387,3797,4776,null,269508,362247]
[39,35549.75,35654.416666666664,35726.833333333336,35831.583333333336,35904.166666666664,null,235602.66666666666,174066.83333333334,235939,null,39,35549.75,35654.416666666664,35726.833333333336,35831.583333333336,35904.166666666664,null,200052.91666666666,138517.08333333334,200389.25,139012.75,null,39,368719,57878,426597,1086,1837,2923,3676,null,808,1367,2175,2735,null,1256,2125,3382,4253,39,426597,427853,428722,429979,430850,39,426597,427853,428722,429979,430850,null,null,null,null,1256,2125,3382,4253,null,0,1256,2125,3382,4253,null,39,221.72401247401248,222.37681912681913,222.82848232848232,223.48180873180874,223.93451143451142,null,39,332.58601871101871,333.56522869022871,334.24272349272348,335.2227130977131,335.9017671517671,null,39,110.86200623700624,111.18840956340956,111.41424116424116,111.74090436590437,111.96725571725571,null,39,274323,368719,368719,7462,376181,1006,1702,2708,3405,null,null,null,null,null,39,808,1367,2175,2735,1086,1837,2923,3676,null,274323,368719]
[40,36187.833333333336,36259.5,36309.083333333336,36380.666666666664,36430.416666666664,null,173166.75,131029.75,173128.66666666666,null,40,36187.833333333336,36259.5,36309.083333333336,36380.666666666664,36430.416666666664,null,136978.91666666666,94841.916666666672,136940.83333333334,95281.666666666672,null,40,375337,58917,434254,743,1258,2000,2516,null,553,936,1488,1872,null,860,1455,2314,2911,40,434254,435114,435709,436568,437165,40,434254,435114,435709,436568,437165,null,null,null,null,860,1455,2314,2911,null,0,860,1455,2314,2911,null,40,225.70374220374219,226.15072765072765,226.45997920997922,226.9064449064449,227.21673596673597,null,40,338.55561330561329,339.22609147609148,339.68996881496884,340.35966735966736,340.82510395010394,null,40,112.8518711018711,113.07536382536382,113.22998960498961,113.45322245322245,113.60836798336798,null,40,279247,375337,375337,7596,382933,688,1165,1853,2330,null,null,null,null,null,40,553,936,1488,1872,743,1258,2000,2516,null,279247,375337]
[41,36839.75,36876.583333333336,36901.916666666664,36938.666666666664,36964.083333333336,null,107240.5,85297,107143.41666666667,null,41,36839.75,36876.583333333336,36901.916666666664,36938.666666666664,36964.083333333336,null,70400.75,48457.25,70303.666666666672,48678.666666666664,null,41,382099,59978,442077,382,645,1026,1290,null,284,480,763,960,null,442,746,1187,1492,41,442077,442519,442823,443264,443569,41,442077,442519,442823,443264,443569,null,null,null,null,442,746,1187,1492,null,0,442,746,1187,1492,null,41,229.76975051975052,229.99948024948026,230.15748440748442,230.38669438669439,230.54521829521829,null,41,344.6546257796258,344.99922037422039,345.23622661122664,345.58004158004155,345.81782744282742,null,41,114.88487525987526,114.99974012474013,115.07874220374221,115.19334719334719,115.27260914760915,null,41,284278,382099,382099,7733,389832,353,598,950,1195,null,null,null,null,null,41,284,480,763,960,382,645,1026,1290,null,284278,382099]
[42,37505.916666666664,37505.916666666664,37505.916666666664,37505.916666666664,37505.916666666664,null,37505.916666666664,37505.916666666664,37505.916666666664,null,42,37505.916666666664,37505.916666666664,37505.916666666664,37505.916666666664,37505.916666666664,null,0,0,0,0,null,42,389008,61063,450071,0,0,0,0,null,0,0,0,0,null,0,0,0,0,42,450071,450071,450071,450071,450071,42,450071,450071,450071,450071,450071,null,null,null,null,0,0,0,0,null,0,0,0,0,0,null,42,233.92463617463616,233.92463617463616,233.92463617463616,233.92463617463616,233.92463617463616,null,42,350.88695426195426,350.88695426195426,350.88695426195426,350.88695426195426,350.88695426195426,null,42,116.96231808731808,116.96231808731808,116.96231808731808,116.96231808731808,116.96231808731808,null,42,289418,389008,389008,7873,396881,0,0,0,0,null,null,null,null,null,42," -   "," -   "," -   "," -   ",0,0,0,0,null,289418,389008]
[43,38339.416666666664,38339.416666666664,38339.416666666664,38339.416666666664,38339.416666666664,null,38339.416666666664,38339.416666666664,38339.416666666664,null,43,38339.416666666664,38339.416666666664,38339.416666666664,38339.416666666664,38339.416666666664,null,0,0,0,0,null,43,397653,62420,460073,0,0,0,0,null,0,0,0,0,null,0,0,0,0,43,460073,460073,460073,460073,460073,43,460073,460073,460073,460073,460073,null,null,null,null,0,0,0,0,null,0,0,0,0,0,null,43,239.12318087318087,239.12318087318087,239.12318087318087,239.12318087318087,239.12318087318087,null,43,358.68477130977129,358.68477130977129,358.68477130977129,358.68477130977129,358.68477130977129,null,43,119.56159043659044,119.56159043659044,119.56159043659044,119.56159043659044,119.56159043659044,null,43,295850,397653,397653,8048,405701,0,0,0,0,null,null,null,null,null,43," -   "," -   "," -   "," -   ",0,0,0,0,null,295850,397653]
[44,39196,39196,39196,39196,39196,null,39196,39196,39196,null,44,39196,39196,39196,39196,39196,null,0,0,0,0,null,44,406538,63814,470352,0,0,0,0,null,0,0,0,0,null,0,0,0,0,44,470352,470352,470352,470352,470352,44,470352,470352,470352,470352,470352,null,null,null,null,0,0,0,0,null,0,0,0,0,0,null,44,244.46569646569645,244.46569646569645,244.46569646569645,244.46569646569645,244.46569646569645,null,44,366.69854469854465,366.69854469854465,366.69854469854465,366.69854469854465,366.69854469854465,null,44,122.23284823284823,122.23284823284823,122.23284823284823,122.23284823284823,122.23284823284823,null,44,302460,406538,406538,8228,414766,0,0,0,0,null,null,null,null,null,44," -   "," -   "," -   "," -   ",0,0,0,0,null,302460,406538]
[45,40076.083333333336,40076.083333333336,40076.083333333336,40076.083333333336,40076.083333333336,null,40076.083333333336,40076.083333333336,40076.083333333336,null,45,40076.083333333336,40076.083333333336,40076.083333333336,40076.083333333336,40076.083333333336,null,0,0,0,0,null,45,415666,65247,480913,0,0,0,0,null,0,0,0,0,null,0,0,0,0,45,480913,480913,480913,480913,480913,45,480913,480913,480913,480913,480913,null,null,null,null,0,0,0,0,null,0,0,0,0,0,null,45,249.95478170478171,249.95478170478171,249.95478170478171,249.95478170478171,249.95478170478171,null,45,374.93217255717258,374.93217255717258,374.93217255717258,374.93217255717258,374.93217255717258,null,45,124.97739085239085,124.97739085239085,124.97739085239085,124.97739085239085,124.97739085239085,null,45,309251,415666,415666,8412,424078,0,0,0,0,null,null,null,null,null,45," -   "," -   "," -   "," -   ",0,0,0,0,null,309251,415666]
[46,40980.333333333336,40980.333333333336,40980.333333333336,40980.333333333336,40980.333333333336,null,40980.333333333336,40980.333333333336,40980.333333333336,null,46,40980.333333333336,40980.333333333336,40980.333333333336,40980.333333333336,40980.333333333336,null,0,0,0,0,null,46,425045,66719,491764,null,null,null,null,null,null,null,null,null,null,0,0,0,0,46,491764,491764,491764,491764,491764,46,491764,491764,491764,491764,491764,null,null,null,null,0,0,0,0,null,0,0,0,0,0,null,46,255.59459459459458,255.59459459459458,255.59459459459458,255.59459459459458,255.59459459459458,null,46,383.39189189189187,383.39189189189187,383.39189189189187,383.39189189189187,383.39189189189187,null,46,127.79729729729729,127.79729729729729,127.79729729729729,127.79729729729729,127.79729729729729,null,46,316229,425045,425045,8602,433647,0,0,0,0,null,null,null,null,null,46," -   "," -   "," -   "," -   ",0,0,0,0,null,316229,425045]
[47,41709.833333333336,41709.833333333336,41709.833333333336,41709.833333333336,41709.833333333336,null,41709.833333333336,41709.833333333336,41709.833333333336,null,47,41709.833333333336,41709.833333333336,41709.833333333336,41709.833333333336,41709.833333333336,null,0,0,0,0,null,47,432611,67907,500518,null,null,null,null,null,null,null,null,null,null,0,0,0,0,47,500518,500518,500518,500518,500518,47,500518,500518,500518,500518,500518,null,null,null,null,0,0,0,0,null,0,0,0,0,0,null,47,260.14449064449065,260.14449064449065,260.14449064449065,260.14449064449065,260.14449064449065,null,47,390.216735966736,390.216735966736,390.216735966736,390.216735966736,390.216735966736,null,47,130.07224532224532,130.07224532224532,130.07224532224532,130.07224532224532,130.07224532224532,null,47,321858,432611,432611,8755,441366,0,0,0,0,null,null,null,null,null,47," -   "," -   "," -   "," -   ",0,0,0,0,null,321858,432611]
[48,43627.083333333336,43627.083333333336,43627.083333333336,43627.083333333336,43627.083333333336,null,43627.083333333336,43627.083333333336,43627.083333333336,null,48,43627.083333333336,43627.083333333336,43627.083333333336,43627.083333333336,43627.083333333336,null,0,0,0,0,null,48,452497,71028,523525,null,null,null,null,null,null,null,null,null,null,0,0,0,0,48,523525,523525,523525,523525,523525,48,523525,523525,523525,523525,523525,null,null,null,null,0,0,0,0,null,0,0,0,0,0,null,48,272.10239085239084,272.10239085239084,272.10239085239084,272.10239085239084,272.10239085239084,null,48,408.15358627858626,408.15358627858626,408.15358627858626,408.15358627858626,408.15358627858626,null,48,136.05119542619542,136.05119542619542,136.05119542619542,136.05119542619542,136.05119542619542,null,48,336653,452497,452497,9158,461655,0,0,0,0,null,null,null,null,null,48," -   "," -   "," -   "," -   ",0,0,0,0,null,336653,452497]
[49,46554.916666666664,46554.916666666664,46554.916666666664,46554.916666666664,46554.916666666664,null,46554.916666666664,46554.916666666664,46554.916666666664,null,49,46554.916666666664,46554.916666666664,46554.916666666664,46554.916666666664,46554.916666666664,null,0,0,0,0,null,49,482864,75795,558659,null,null,null,null,null,null,null,null,null,null,0,0,0,0,49,558659,558659,558659,558659,558659,49,558659,558659,558659,558659,558659,null,null,null,null,0,0,0,0,null,0,0,0,0,0,null,49,290.36330561330561,290.36330561330561,290.36330561330561,290.36330561330561,290.36330561330561,null,49,435.54495841995845,435.54495841995845,435.54495841995845,435.54495841995845,435.54495841995845,null,49,145.18165280665281,145.18165280665281,145.18165280665281,145.18165280665281,145.18165280665281,null,49,359246,482864,482864,9772,492636,0,0,0,0,null,null,null,null,null,49," -   "," -   "," -   "," -   ",0,0,0,0,null,359246,482864,{"$f":"DL53*1.020238","v":492636.20163199998}]
[50,49804.833333333336,49804.833333333336,49804.833333333336,49804.833333333336,49804.833333333336,null,49804.833333333336,49804.833333333336,49804.833333333336,null,50,{"$f":"$BD54/12","v":50979.583333333336},{"$f":"$BD54/12","v":50979.583333333336},50979.583333333336,50979.583333333336,50979.583333333336,null,50979.583333333336,50979.583333333336,50979.583333333336,50979.583333333336,null,50,516572,81086,597658,null,null,null,null,null,null,null,null,null,null,0,0,0,0,50,597658,597658,597658,597658,597658,50,{"$f":"$BD54","v":611755},{"$f":"$BD54","v":611755},611755,611755,611755,{"$f":"VLOOKUP(AV54,Pens_grundbeløb,IF(beregningsdato<$DF$3,2,3),FALSE)","v":528756},{"$f":"ROUND(BB54*($AL$4),0)","v":82999},{"$f":"SUM(BB54:BC54)","v":611755},null,0,0,0,0,null,611755,611755,611755,611755,611755,null,50,310.63305613305613,310.63305613305613,310.63305613305613,310.63305613305613,310.63305613305613,null,50,465.94958419958419,465.94958419958419,465.94958419958419,465.94958419958419,465.94958419958419,null,50,155.31652806652806,155.31652806652806,155.31652806652806,155.31652806652806,155.31652806652806,null,50,384324,516572,516572,10454,527026,0,0,0,0,null,null,null,null,null,50," -   "," -   "," -   "," -   ",0,0,0,0,50,393389,528756,{"$f":"DL54*1.020238","v":539456.96392799995}]
[51,55013.083333333336,55013.083333333336,55013.083333333336,55013.083333333336,55013.083333333336,null,55013.083333333336,55013.083333333336,55013.083333333336,null,51,{"$f":"$BD55/12","v":56493.916666666664},56493.916666666664,56493.916666666664,56493.916666666664,56493.916666666664,null,56493.916666666664,56493.916666666664,56493.916666666664,56493.916666666664,null,51,570591,89566,660157,null,null,null,null,null,null,null,null,null,null,0,0,0,0,51,660157,660157,660157,660157,660157,51,{"$f":"$BD55","v":677927},677927,677927,677927,677927,585950,{"$f":"ROUND(BB55*($AL$4),0)","v":91977},{"$f":"SUM(BB55:BC55)","v":677927},null,0,0,0,0,null,677927,677927,677927,677927,677927,null,51,343.11694386694387,343.11694386694387,343.11694386694387,343.11694386694387,343.11694386694387,null,51,514.67541580041575,514.67541580041575,514.67541580041575,514.67541580041575,514.67541580041575,null,51,171.55847193347194,171.55847193347194,171.55847193347194,171.55847193347194,171.55847193347194,null,51,424514,570591,570591,11548,582139,null,null,null,null,null,null,null,null,null,51," -   "," -   "," -   "," -   ",0,0,0,0,51,435941,585950,597808.45609999995]
[52,62598.083333333336,62598.083333333336,62598.083333333336,62598.083333333336,62598.083333333336,null,62598.083333333336,62598.083333333336,62598.083333333336,null,52,64340.666666666664,64340.666666666664,64340.666666666664,64340.666666666664,64340.666666666664,null,64340.666666666664,64340.666666666664,64340.666666666664,64340.666666666664,null,52,649262,101915,751177,null,null,null,null,null,null,null,null,null,null,0,0,0,0,52,751177,751177,751177,751177,751177,52,772088,772088,772088,772088,772088,667336,104752,772088,null,0,0,0,0,null,772088,772088,772088,772088,772088,null,52,390.42463617463619,390.42463617463619,390.42463617463619,390.42463617463619,390.42463617463619,null,52,585.63695426195432,585.63695426195432,585.63695426195432,585.63695426195432,585.63695426195432,null,52,195.2123180873181,195.2123180873181,195.2123180873181,195.2123180873181,195.2123180873181,null,52,483044,649262,649262,13140,662402,null,null,null,null,null,null,null,null,null,52," -   "," -   "," -   "," -   ",0,0,0,0,52,496491,667336,680841.54596799996]
[53,68730.25,68730.25,68730.25,68730.25,68730.25,null,68730.25,68730.25,68730.25,null,53,71621.833333333328,71621.833333333328,71621.833333333328,71621.833333333328,71621.833333333328,null,71621.833333333328,71621.833333333328,71621.833333333328,71621.833333333328,null,53,712865,111898,824763,null,null,null,null,null,null,null,null,null,null,0,0,0,0,53,824763,824763,824763,824763,824763,53,859462,859462,859462,859462,859462,742856,116606,859462,null,0,0,0,0,null,859462,859462,859462,859462,859462,null,53,428.67099792099793,428.67099792099793,428.67099792099793,428.67099792099793,428.67099792099793,null,53,643.0064968814969,643.0064968814969,643.0064968814969,643.0064968814969,643.0064968814969,null,53,214.33549896049897,214.33549896049897,214.33549896049897,214.33549896049897,214.33549896049897,null,53,530364,712865,712865,14427,727292,null,null,null,null,null,null,null,null,null,53," -   "," -   "," -   "," -   ",0,0,0,0,53,552677,742856,757889.91972799995]
[54,76905.5,76905.5,76905.5,76905.5,76905.5,null,76905.5,76905.5,76905.5,null,54,80696.75,80696.75,80696.75,80696.75,80696.75,null,80696.75,80696.75,80696.75,80696.75,null,54,797658,125208,922866,null,null,null,null,null,null,null,null,null,null,0,0,0,0,54,922866,922866,922866,922866,922866,54,968361,968361,968361,968361,968361,836980,131381,968361,null,0,0,0,0,null,968361,968361,968361,968361,968361,null,54,479.66008316008316,479.66008316008316,479.66008316008316,479.66008316008316,479.66008316008316,null,54,719.49012474012477,719.49012474012477,719.49012474012477,719.49012474012477,719.49012474012477,null,54,239.83004158004158,239.83004158004158,239.83004158004158,239.83004158004158,239.83004158004158,null,54,593449,797658,797658,16143,813801,null,null,null,null,null,null,null,null,null,54," -   "," -   "," -   "," -   ",0,0,0,0,54,622704,836980,853918.80123999994]
[55,86732.25,86732.25,86732.25,86732.25,86732.25,null,86732.25,86732.25,86732.25,null,55,90523.416666666672,90523.416666666672,90523.416666666672,90523.416666666672,90523.416666666672,null,90523.416666666672,90523.416666666672,90523.416666666672,90523.416666666672,null,55,899580,141207,1040787,null,null,null,null,null,null,null,null,null,null,0,0,0,0,55,1040787,1040787,1040787,1040787,1040787,55,1086281,1086281,1086281,1086281,1086281,938902,147379,1086281,null,0,0,0,0,null,1086281,1086281,1086281,1086281,1086281,null,55,540.94958419958425,540.94958419958425,540.94958419958425,540.94958419958425,540.94958419958425,null,55,811.42437629937638,811.42437629937638,811.42437629937638,811.42437629937638,811.42437629937638,null,55,270.47479209979213,270.47479209979213,270.47479209979213,270.47479209979213,270.47479209979213,null,55,669278,899580,899580,18206,917786,null,null,null,null,null,null,null,null,null,55," -   "," -   "," -   "," -   ",0,0,0,0,55,698533,938902,957903.49867599993]
[56,97751.416666666672,97751.416666666672,97751.416666666672,97751.416666666672,97751.416666666672,null,97751.416666666672,97751.416666666672,97751.416666666672,null,56,101542.91666666667,101542.91666666667,101542.91666666667,101542.91666666667,101542.91666666667,null,101542.91666666667,101542.91666666667,101542.91666666667,101542.91666666667,null,56,1013870,159147,1173017,null,null,null,null,null,null,null,null,null,null,0,0,0,0,56,1173017,1173017,1173017,1173017,1173017,56,1218515,1218515,1218515,1218515,1218515,1053195,165320,1218515,null,0,0,0,0,null,1218515,1218515,1218515,1218515,1218515,null,56,609.67619542619548,609.67619542619548,609.67619542619548,609.67619542619548,609.67619542619548,null,56,914.51429313929316,914.51429313929316,914.51429313929316,914.51429313929316,914.51429313929316,null,56,304.83809771309774,304.83809771309774,304.83809771309774,304.83809771309774,304.83809771309774,null,56,754309,1013870,1013870,20519,1034389,null,null,null,null,null,null,null,null,null,56," -   "," -   "," -   "," -   ",0,0,0,0,56,783566,1053195,1074509.5604099999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Y61*valgt_regulering,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["2006-10-01",4131.67,4204.9799999999996,4265.26,4358.1099999999997,4420,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["2007-04-01",4229.54,4303.8900000000003,4365.01,4459.17,4521.93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Forside","index":3,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[14,3,14,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Lønniveau:","2024-10-01"]

{"sheet":"Omregningstabel ","index":4,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[null,null,null,1.362716,1.3824959999999999,1.3980790000000001,1.018559,1.040662,1.0511569999999999,1.061566,1.0834220000000001,1.0886800000000001,1.0926750000000001,1.109523,1.1200380000000001,1.1244540000000001]
[]
[]
[]
[]
[]
[null,"Indtast beløb:",1000]
[]
[]
[null,null,"1/10 '84"]
[null,null,{"$f":"Beløb","v":1000},"1/4 '98"]
[null,"1/4-98",{"$f":"Beløb*_1_4_1998","v":1362.7160000000001},{"$f":"Beløb","v":1000},"1/10 '98"]
[null,"1/10-98",{"$f":"Beløb*_1_10_1998","v":1382.4959999999999},{"$f":"Beløb/_1_4_1998*_1_10_1998","v":1014.515130078461},{"$f":"Beløb","v":1000},"1/4 '99"]
[null,"1/4-99",{"$f":"Beløb*_1_4_1999","v":1398.0790000000002},{"$f":"Beløb/_1_4_1998*_1_4_1999","v":1025.9503814441161},{"$f":"Beløb/_1_10_1998*_1_4_1999","v":1011.2716420156008},{"$f":"Beløb","v":1000}]
[null,"Grundbeløb pr. 31/3-00",{"$f":"ROUND(C14,-2)","v":1400},{"$f":"ROUND(D14,-2)","v":1000},{"$f":"ROUND(E14,-2)","v":1000},{"$f":"ROUND(F14,-2)","v":1000},"1/4 '00"]
[null,"1/4-00",{"$f":"Nyt_beløb_1*_1_4_2000","v":1425.9826},{"$f":"Nyt_beløb_2*_1_4_2000","v":1018.559},{"$f":"Nyt_beløb_3*_1_4_2000","v":1018.559},{"$f":"Nyt_beløb_4*_1_4_2000","v":1018.559},{"$f":"Beløb","v":1000},"1/4 '01"]
[null,"1/4-01",{"$f":"Nyt_beløb_1*_1_4_2001","v":1456.9268},{"$f":"Nyt_beløb_2*_1_4_2001","v":1040.662},{"$f":"Nyt_beløb_3*_1_4_2001","v":1040.662},{"$f":"Nyt_beløb_4*_1_4_2001","v":1040.662},{"$f":"beløb_4_00/_1_4_2000*_1_4_2001","v":1021.7002647858396},{"$f":"Beløb","v":1000},"1/10 '01"]
[null,"1/10-01",{"$f":"Nyt_beløb_1*_1_10_2001","v":1471.6197999999999},{"$f":"Nyt_beløb_2*_1_10_2001","v":1051.1569999999999},{"$f":"Nyt_beløb_3*_1_10_2001","v":1051.1569999999999},{"$f":"Nyt_beløb_4*_1_10_2001","v":1051.1569999999999},{"$f":"beløb_4_00/_1_4_2000*_1_10_2001","v":1032.0040370759082},{"$f":"beløb_4_01/_1_4_2001*_1_10_2001","v":1010.0849267101133},{"$f":"Beløb","v":1000},"1/4 '02"]
[null,"1/4-02",{"$f":"Nyt_beløb_1*_1_4_2002","v":1486.1923999999999},{"$f":"Nyt_beløb_2*_1_4_2002","v":1061.566},{"$f":"Nyt_beløb_3*_1_4_2002","v":1061.566},{"$f":"Nyt_beløb_4*_1_4_2002","v":1061.566},{"$f":"beløb_4_00/_1_4_2000*_1_4_2002","v":1042.2233763581687},{"$f":"beløb_4_01/_1_4_2001*_1_4_2002","v":1020.0872137158848},{"$f":"beløb_10_01/_1_10_2001*_1_4_2002","v":1009.9024218075892},{"$f":"Beløb","v":1000},"1/4 '03"]
[null,"1/4-03",{"$f":"Nyt_beløb_1*_1_4_2003","v":1516.7908000000002},{"$f":"Nyt_beløb_2*_1_4_2003","v":1083.422},{"$f":"Nyt_beløb_3*_1_4_2003","v":1083.422},{"$f":"Nyt_beløb_4*_1_4_2003","v":1083.422},{"$f":"beløb_4_00/_1_4_2000*_1_4_2003","v":1063.6811416913504},{"$f":"beløb_4_01/_1_4_2001*_1_4_2003","v":1041.0892297403002},{"$f":"beløb_10_01/_1_10_2001*_1_4_2003","v":1030.6947487387708},{"$f":"beløb_4_02/_1_4_2002*_1_4_2003","v":1020.5884514010435},{"$f":"Beløb","v":1000},"1/8 '03"]
[null,"1/8-03",{"$f":"Nyt_beløb_1*_1_8_2003","v":1524.152},{"$f":"Nyt_beløb_2*_1_8_2003","v":1088.68},{"$f":"Nyt_beløb_3*_1_8_2003","v":1088.68},{"$f":"Nyt_beløb_4*_1_8_2003","v":1088.68},{"$f":"beløb_4_00/_1_4_2000*_1_8_2003","v":1068.8433365175706},{"$f":"beløb_4_01/_1_4_2001*_1_8_2003","v":1046.1417828267008},{"$f":"beløb_10_01/_1_10_2001*_1_8_2003","v":1035.6968559406446},{"$f":"beløb_4_02/_1_4_2002*_1_8_2003","v":1025.5415113144168},{"$f":"beløb_4_03/_1_4_2003*_1_8_2003","v":1004.853141250593},{"$f":"Beløb","v":1000},"1/10 '03"]
[null,"1/10-03",{"$f":"Nyt_beløb_1*_1_10_2003","v":1529.7450000000001},{"$f":"Nyt_beløb_2*_1_10_2003","v":1092.675},{"$f":"Nyt_beløb_3*_1_10_2003","v":1092.675},{"$f":"Nyt_beløb_4*_1_10_2003","v":1092.675},{"$f":"beløb_4_00/_1_4_2000*_1_10_2003","v":1072.7655442640043},{"$f":"beløb_4_01/_1_4_2001*_1_10_2003","v":1049.9806853714272},{"$f":"beløb_4_01/_1_4_2001*_1_10_2003","v":1049.9806853714272},{"$f":"beløb_4_02/_1_4_2002*_1_10_2003","v":1029.3048194836686},{"$f":"beløb_4_03/_1_4_2003*_1_10_2003","v":1008.5405317595545},{"$f":"beløb_8_03/_1_8_2003*_1_10_2003","v":1003.6695815115553},{"$f":"Beløb","v":1000},"1/4 '04"]
[null,"1/4 '04",{"$f":"Nyt_beløb_1*_1_4_2004","v":1553.3322000000001},{"$f":"Nyt_beløb_2*_1_4_2004","v":1109.5230000000001},{"$f":"Nyt_beløb_3*_1_4_2004","v":1109.5230000000001},{"$f":"Nyt_beløb_4*_1_4_2004","v":1109.5230000000001},{"$f":"beløb_4_00/_1_4_2000*_1_4_2004","v":1089.3065595611056},{"$f":"beløb_4_01/_1_4_2001*_1_4_2004","v":1066.1703800081104},{"$f":"beløb_4_01/_1_4_2001*_1_4_2004","v":1066.1703800081104},{"$f":"beløb_4_02/_1_4_2002*_1_4_2004","v":1045.1757121083381},{"$f":"beløb_4_03/_1_4_2003*_1_4_2004","v":1024.091258992341},{"$f":"beløb_8_03/_1_8_2003*_1_4_2004","v":1019.1452033655436},{"$f":"beløb_10_03/_1_10_2003*_1_4_2004","v":1015.4190404283066},{"$f":"Beløb","v":1000},"1/8 '04"]
[null,"1/8 '04",{"$f":"Nyt_beløb_1*_1_8_2004","v":1568.0532000000001},{"$f":"Nyt_beløb_2*_1_8_2004","v":1120.038},{"$f":"Nyt_beløb_3*_1_8_2004","v":1120.038},{"$f":"Nyt_beløb_4*_1_8_2004","v":1120.038},{"$f":"beløb_4_00/_1_4_2000*_1_8_2004","v":1099.6299674343854},{"$f":"beløb_4_01/_1_4_2001*_1_8_2004","v":1076.2745252541172},{"$f":"beløb_4_01/_1_4_2001*_1_8_2004","v":1076.2745252541172},{"$f":"beløb_4_02/_1_4_2002*_1_8_2004","v":1055.0808899305366},{"$f":"beløb_4_03/_1_4_2003*_1_8_2004","v":1033.7966184921481},{"$f":"beløb_8_03/_1_8_2003*_1_8_2004","v":1028.8036888709262},{"$f":"beløb_10_03/_1_10_2003*_1_8_2004","v":1025.0422129178392},{"$f":"beløb_4_04/_1_4_2004*_1_8_2004","v":1009.4770455411921},{"$f":"Beløb","v":1000},"1/10 '04"]
[null,"1/10 '04",{"$f":"Nyt_beløb_1*_1_10_2004","v":1574.2356},{"$f":"Nyt_beløb_2*_1_10_2004","v":1124.4540000000002},{"$f":"Nyt_beløb_3*_1_10_2004","v":1124.4540000000002},{"$f":"Nyt_beløb_4*_1_10_2004","v":1124.4540000000002},{"$f":"beløb_4_00/_1_4_2000*_1_10_2004","v":1103.9655042074146},{"$f":"beløb_4_01/_1_4_2001*_1_10_2004","v":1080.5179779794016},{"$f":"beløb_4_01/_1_4_2001*_1_10_2004","v":1080.5179779794016},{"$f":"beløb_4_02/_1_4_2002*_1_10_2004","v":1059.2407820144956},{"$f":"beløb_4_03/_1_4_2003*_1_10_2004","v":1037.8725925816534},{"$f":"beløb_8_03/_1_8_2003*_1_10_2004","v":1032.8599772201198},{"$f":"beløb_10_03/_1_10_2003*_1_10_2004","v":1029.0836708078798},{"$f":"beløb_4_04/_1_4_2004*_1_10_2004","v":1013.4571342820293},{"$f":"beløb_8_04/_1_8_2004*_1_10_2004","v":1003.9427233718856},{"$f":"Beløb","v":1000}]

{"sheet":"Tillæg_trin","index":5,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,1,1,7]]}
[3]
[]
[null,"Valgt lønniveau: ",{"$f":"Forside!K11","v":"2024-10-01"}]
[]
[null,"Løngruppe",null,3]
[null,"Timer/uge",null,37]
[null,"Pensions-% inkl. evt. fritvalgs-%",null,13.89]
[null,"Særlig feriegodtgørelse, aktuel pct.",null,1.95]
[]
[null,"Stigning:","Fra","Til"]
[null,"Løntrin ",18,19]
[]
[null,"Løn",{"$f":"(VLOOKUP(til_trin,Lønark!A4:F60,løngruppe+2,FALSE)-VLOOKUP(fra_trin,Lønark!A4:F60,løngruppe+2,FALSE))/37*timetal*12","v":4424.0000000000146}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"(VLOOKUP(til_trin,Lønark!L4:Q60,løngruppe+2,FALSE)-VLOOKUP(fra_trin,Lønark!L4:Q60,løngruppe+2,FALSE))/37*timetal*pensionsstatus%*12","v":614.49360000000206}]
[null,"Ferietillæg",{"$f":"ferie_pct%*C13","v":86.268000000000285}]
[null,"Årlig bruttoudgift i alt",{"$f":"ROUND(SUM(C13:C15),0)","v":5125}]

{"sheet":"Tillæg_kr","index":6,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[[9,1,9,2]]}
[2]
[]
[null,null,"Valgt lønniveau:",{"$f":"Forside!K11","v":"2024-10-01"}]
[]
[{"$f":"VLOOKUP(dummy,reg_procenter,2,FALSE)","v":{"$error":"#NAME?"}},null,"Årligt beløb, 31.3.2000 niveau ",12900]
[null,null,"Timer/uge",30]
[null,null,"Pension-% inkl. evt. fritvalgs-%",13.89]
[null,null,"Særlig feriegodtg., aktuel pct.",1.95]
[]
[]
[null,null,"bruttoudgift / år","bruttoudgift / md"]
[null,"Løn",{"$f":"kr*valgt_regulering/37*timetal","v":12101.280810810811},{"$f":"beløb/12","v":1008.4400675675676}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"beløb*pensionsstatus%","v":1680.8679046216216},{"$f":"C13/12","v":140.07232538513514}]
[null,"Ferietillæg",{"$f":"D8%*(C12)","v":235.9749758108108},{"$f":"C14/12","v":19.664581317567567}]
[null,"Bruttoudgift i alt",{"$f":"ROUND(SUM(C12:C14),0)","v":14018},{"$f":"ROUND(SUM(D12:D14),0)","v":1168}]

{"sheet":"Omregner_gl. til nyt_niveau","index":7,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":true,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Omregner A\n- fra grundbeløb 31.3.2000 niveau til nyt grundbeløb pr. 31.3.2018 - RLTN",null,null,null,null,null,null,null,"Omregner B\n- fra nutidskroner tilbage til nyt grundbeløb pr. 31.3.2018 - RLTN"]
[]
[null,"Brug omregneren, når satser og tillæg i lokale aftaler skal omlægges til ny niveau på regionsområdet",null,null,null,null,null,null,null,"Brug omregneren, når du vil finde ud af hvad et givent beløb i nutidskroner svarer til i nyt grundbeløb "]
[]
[]
[]
[null,"Kun ÅRLIGE grundbeløb;\nIndtast årligt grundbeløb pr. 31.3.2000",null,"Nyt grundbeløb \npr. 31.3.2018",null,{"$f":"\"Aktuelt beløb \npr. \"&DAY(beregningsdato)&\".\"&MONTH(beregningsdato)&\".\"&YEAR(beregningsdato)","v":"Aktuelt beløb \npr. 1.10.2024"},null,null,null,{"$f":"\"Tillæg pr. år;\nIndtast beløb i nutidskroner (\"&DAY(beregningsdato)&\".\"&MONTH(beregningsdato)&\".\"&YEAR(beregningsdato)&\")\"","v":"Tillæg pr. år;\nIndtast beløb i nutidskroner (1.10.2024)"},null,"svarer til:\nårligt grundbeløb (31/3-2018)"]
[null,1500,"=>",{"$f":"ROUND(B9*1.344105,0)","v":2016},"=>",{"$f":"ROUND(D9*valgt_regulering,2)","v":2332.4499999999998},null,null,null,31000,"=>",{"$f":"ROUND(J9/1.020238,0)","v":30385}]
[]
[]
[]
[null,"Grundbeløb pr. måned/uge eller pr. tidsenhed\nIndtast grundbeløb pr. 31.3.2000",null,"Nyt grundbeløb \npr. 31.3.2018",null,{"$f":"\"Aktuelt beløb \npr. \"&DAY(beregningsdato)&\".\"&MONTH(beregningsdato)&\".\"&YEAR(beregningsdato)","v":"Aktuelt beløb \npr. 1.10.2024"},null,null,null,{"$f":"\"Tillæg pr. måned/uge eller pr. tidsenhed;\nIndtast beløb i nutidskroner (\"&DAY(beregningsdato)&\".\"&MONTH(beregningsdato)&\".\"&YEAR(beregningsdato)&\")\"","v":"Tillæg pr. måned/uge eller pr. tidsenhed;\nIndtast beløb i nutidskroner (1.10.2024)"},null,"svarer til:\n grundbeløb \n(31/3-2018)"]
[null,34.85,"=>",{"$f":"ROUND(B14*1.344105,2)","v":46.84},"=>",{"$f":"ROUND(D14*valgt_regulering,2)","v":54.19},null,null,null,47.8,"=>",{"$f":"J14/valgt_regulering","v":41.314813694391383}]

{"sheet":"Tid op_ned","index":8,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[2,"Valgt lønniveau: ",{"$f":"Forside!K11","v":"2024-10-01"}]
[]
[null,"Grundoplysninger:"]
[null,"Løngruppe",0]
[null,"Pensions-% inkl. evt. fritvalgs-%",14.7]
[null,"Særlig feriegodtgørelse, aktuel procent",1.95]
[]
[]
[null,"Lønsammensætning (trin i alt og grundbeløb i alt)","Før ændring",null,"Efter ændring"]
[]
[null,"Løndele:","I alt"]
[]
[null,"Løntrin - centralt og lokalt aftalte",22,null,22]
[]
["2018-10-01",{"$f":"IF(C1<A15,\"Tillæg (grundbeløb 31.3.2000) kr./år centralt og lokalt aftalte\",\"Tillæg (grundbeløb 31.3.2018) kr./år centralt og lokalt aftalte\")","v":"Tillæg (grundbeløb 31.3.2018) kr./år centralt og lokalt aftalte"},0,null,1300]
[]
[]
[null,null,"Før ændring",null,"Efter ændring",null,null,{"$f":"\"Difference \"&IF(C24>E24,\"(lønnedgang)\",\"(lønstigning)\")","v":"Difference (lønnedgang)"}]
[null,"Timer/uge",37,null,35,null,null,{"$f":"C19-timetal_ny","v":2}]
[]
[null,"Fast månedsløn",{"$f":"(VLOOKUP(C13,Lønkort_løn,$C$4+2,FALSE)+((C15)*valgt_regulering))/12/37*C19","v":26802.333333333332},null,{"$f":"(VLOOKUP(E13,Lønkort_løn,$C$4+2,FALSE)+((E15)*valgt_regulering))/12/37*E19","v":25472.121925675674},null,null,{"$f":"E21-C21","v":-1330.2114076576581}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"((VLOOKUP(C13,Lønkort_pens,$C$4+2,FALSE)+((C15)*valgt_regulering))/12/37*C19*$C$5%)","v":3939.9429999999998},null,{"$f":"((VLOOKUP(E13,Lønkort_pens,$C$4+2,FALSE)+((E15)*valgt_regulering))/12/37*E19*$C$5%)","v":3744.4019230743238},null,null,{"$f":"E22-C22","v":-195.54107692567595}]
[null,"Ferietillæg",{"$f":"$C$6%*C21","v":522.64549999999997},null,{"$f":"$C$6%*E21","v":496.70637755067565},null,null,{"$f":"E23-C23","v":-25.939122449324316}]
[null,"Månedsløn, brutto",{"$f":"SUM(C21:C23)","v":31264.92183333333},null,{"$f":"SUM(E21:E23)","v":29713.230226300675},null,null,{"$f":"E24-C24","v":-1551.6916070326552}]
[]
[null,"Fast løn, år",{"$f":"(VLOOKUP(C13,Lønkort_løn,$C$4+2,FALSE)+((C15)*valgt_regulering))/37*C19","v":321628},{"$f":"D21*12","v":0},{"$f":"(VLOOKUP(E13,Lønkort_løn,$C$4+2,FALSE)+((E15)*valgt_regulering))/37*E19","v":305665.46310810809},null,null,{"$f":"E26-C26","v":-15962.536891891912}]
[null,"Pension inkl. evt. fritvalgstillæg, år",{"$f":"((VLOOKUP(C13,Lønkort_pens,$C$4+2,FALSE)+((C15)*valgt_regulering))/37*C19*$C$5%)","v":47279.315999999999},0,{"$f":"((VLOOKUP(E13,Lønkort_pens,$C$4+2,FALSE)+((E15)*valgt_regulering))/37*E19*$C$5%)","v":44932.823076891887},null,null,{"$f":"E27-C27","v":-2346.4929231081114}]
[null,"Ferietillæg, år",{"$f":"C23*12","v":6271.7459999999992},null,{"$f":"E23*12","v":5960.4765306081081},null,null,{"$f":"E28-C28","v":-311.26946939189111}]
[null,"Årsløn, brutto",{"$f":"SUM(C26:C28)","v":375179.06199999998},null,{"$f":"SUM(E26:E28)","v":356558.76271560806},null,null,{"$f":"E29-C29","v":-18620.29928439192}]
[]
[null,"Timeløn",{"$f":"ROUND((VLOOKUP(C13,Lønkort_løn,$C$4+2,FALSE)+((C15)*valgt_regulering))/1924,2)","v":167.17},{"$f":"D26/timetal_ny*37/1924","v":0},{"$f":"ROUND((VLOOKUP(E13,Lønkort_løn,$C$4+2,FALSE)+((E15)*valgt_regulering))/1924,2)","v":167.95},null,null,{"$f":"E31-C31","v":0.78000000000000114}]

{"sheet":"Samlet_omk","index":9,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[2,"Valgt lønniveau: ",{"$f":"Forside!K11","v":"2024-10-01"}]
[]
[null,"Løngruppe",0]
[null,"Timer/uge",37]
[null,"Pensions-% ",13.89]
[null,"Særlig feriegodtgørelse, aktuel pct.",1.95]
[]
[null,"Løntrin ",13]
[]
["2018-10-01",{"$f":"IF(C1<A10,\"Reguleret tillæg (niveau 31.3.2000) kr./år\",\"Reguleret tillæg (niveau 31.3.2018) kr./år\")","v":"Reguleret tillæg (niveau 31.3.2018) kr./år"},12903]
[]
[]
[null,"Løn/måned",{"$f":"(VLOOKUP(fra_trin,Lønkort_løn,løngruppe+2,FALSE)+(C10*valgt_regulering))/12/37*timetal","v":24580.365325833332}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"(VLOOKUP(fra_trin,Lønkort_pens,løngruppe+2,FALSE)+(C10*valgt_regulering))/12/37*timetal*pensionsstatus%","v":3414.2127437582499}]
[null,"Ferietillæg",{"$f":"C6%*C13","v":479.31712385374999}]
[null,"Månedlig bruttoudgift i alt",{"$f":"SUM(C13:C15)","v":28473.895193445333}]
[]
[null,"Løn/år",{"$f":"(VLOOKUP(fra_trin,Lønkort_løn,løngruppe+2,FALSE)+(C10*valgt_regulering))/37*timetal","v":294964.38390999998}]
[null,"Pension ",{"$f":"(VLOOKUP(fra_trin,Lønkort_pens,løngruppe+2,FALSE)+(C10*valgt_regulering))/37*timetal*pensionsstatus%","v":40970.552925098993}]
[null,"Ferietillæg",{"$f":"C15*12","v":5751.8054862449999}]
[null,"Årlig bruttoudgift i alt",{"$f":"SUM(C18:C20)","v":341686.74232134398}]
[]
[null,"Timeløn",{"$f":"ROUND(VLOOKUP(fra_trin,Lønark!A4:AU60,løngruppe+43,FALSE)/1924,2)+ROUND(C10*valgt_regulering/1924,2)","v":153.31}]

{"sheet":"Omregner_'18_niveau","index":10,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"2018-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F11<L1,\"00\",\"18\")","v":"18"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Valgt lønniveau:",null,{"$f":"Forside!K11","v":"2024-10-01"},null,"Timetal:",37]
[]
[null,{"$f":"\"1) Grundbeløb pr. 31-3-20\"&L2&\" omregnet til nutidskr.\"","v":"1) Grundbeløb pr. 31-3-2018 omregnet til nutidskr."}]
[null,null,"Årligt grundbeløb:",null,34409]
[]
[null,null,null,null,"år","måned"]
[null,null,"Aktuelt beløb",null,{"$f":"ROUND(kr_omregnes*valgt_regulering,0)/37*I11","v":39810.000000000007},{"$f":"ROUND(kr_omregnes*valgt_regulering,2)/37*I11/12","v":3317.5149999999994}]
[]
[]
[null,{"$f":"\"2) Beløb der skal omregnes til '31-3-20\"&L2&\"-niveau'\"","v":"2) Beløb der skal omregnes til '31-3-2018-niveau'"}]
[null,null,"Månedligt beløb",null,390.93]
[]
[null,null,null,null,"år","måned"]
[null,null,{"$f":"\"Grundbeløb pr. 31-3-20\"&L2","v":"Grundbeløb pr. 31-3-2018"},null,{"$f":"ROUND(E21*12/valgt_regulering,0)/I11*37","v":4055},{"$f":"ROUND(E21*12/valgt_regulering,2)/I11*37/12","v":337.89083333333332}]